Hi All. I am new to qlik sense.Your assistance would really help us.
Please find the attached requirement.
Quarter values are dynamic .
Here we show 5 closed qtrs in case of 1st month of quarter and 4 closed quarter +QTD in 2nd and 3rd month.
for dynamic quarters derivation we have a calender table with us and calcualting required qtrs from it making query.
The qtrs that we are receiving from this query,we are passing to the required data view for fetching that particular qtrs data.
We generate this data for few product units and giving flexibility to user to select a product in filter pane.The requirement is to fix the header quarter values irrespective of product has the data or not in any qtr.
If there is no data for any of the quarter it should place '-' or 0 for total ,Average,poor
for e.g, lets say user selected 'A' product from filter pane , and product 'A has only data for Q220', my visualization is showing Q220 data only.
It should be like for all the required qtrs should be there in header , for which data is present it should populate data else '-' or 0 for remaining qtrs.
