rolling 6/4 months in bar /pivot table with multiple or 2 diemsnion

[manoranjan_321988]

Hi Team,

PFA  of my sample data and QVF, I want to show the rolling 6 months data as default with monthyear dim and if there is no data for the rolling months it has to show zero in the bar chart and  if user select any timeframe monthyear  dim has to be changed accordingly as per the selected timeframe example week or year or date, All these are achieved.

now the issue is if i add another dim in the chart and disable the include null value , i am not getting the zero value. bar chart has to  show allways rolling 6 bars, if no data then it shd be zero and similarly pivot shd show the rolling 4 months.

[manoranjan_321988]

Hi, I totally agree on your point , i tried by generating missing data for the fact , the 21k raw records went to 8.3million rows record, attached my qvf and below are the screen shot. refer the app second sheet.

Note: generating missing data concepts comes in to picture with cartesian join concepts in the qlik script 

if we use straight table with 6 measure, then how the rolling logic come in to picture could you pls share your qvf file.

i will try to close this thread after seeing your qvf file with straight table logic, please be in touch with my scenarios  in upcoming days with your helping hands  

[olofmalmstrom]

Sorry, no qvf to share, just a thought in my head that you could create 6 measures, one that calculates the value for for the max yearmonth, on for max yearmonth-1 etc...

Good luck 🙂

[manoranjan_321988]

will try and reply to you asap and close the thread after my try.