topic Help with Current Year V's Previous Year with missing data in QlikView

Help with Current Year V's Previous Year with missing data

helen_pip — Wed, 16 Oct 2013 14:07:41 GMT

Hello

I have a dataset dating back from April 2012 - Current Date

In the dataset there is a field called CAB and this is only populated from August 2012

In my document I am showing data for the

Total:

Current Year

Last Year

Variance

% Variance

The little buttons change accordingly, except when I select an option from the CAB list box.

When I select an option in the CAB list box and then Apr from the Month list box, my Last Year box show this years information

I require some assistance in writing the expression for the text box's@

Current Year

Last Year

Please find attached an example of my problem

Anonymous — Wed, 16 Oct 2013 14:14:35 GMT

Helen

Try creating a separate but linked Calendar table

Best Regards, Bill

helen_pip — Wed, 16 Oct 2013 14:18:41 GMT

Hello

Thank you for your suggestion

Do you have any examples of how I would do this and then apply this?

Thanks

Helen

Anonymous — Wed, 16 Oct 2013 14:22:10 GMT

Helen

Best Regards, Bill

Anonymous — Wed, 16 Oct 2013 14:23:18 GMT

Helen

Best Regards, Bill

Anonymous — Wed, 16 Oct 2013 14:25:17 GMT

Helen

Just posted another url, but it is from outside the QlikCommunity and it needs moderator approval.

Try Googling QlikView Master Calendar or use the QlikCommunity search.

Best Regards, Bill