Multilevel visualisation in QlikView

[nyakeyac]

Hi 

I have a requirement where a user would like to see past data that fulfills a certain condition when the current data does not meet the conditions. 

For example the most complete data is available in Nov but not in Dec and Jan. When dates are selected for the whole month of Nov, the correct data shows up but when Dec and Jan are selected, they are incomplete. The user wants the Nov data to show up when Dec and Nov are selected.

How can I make that data show up on a KPI object when Dec and Jan are selected?

I hope this makes sense. 

CN 

[Or · Accepted solution]

How can you tell that the month isn't complete yet?

Let's assume we have a flag CompleteMonth which is 1 when true, 0 when not.

Let's assume we can write a flag LastCompleteMonth which is 1 for the last complete month (nov) and 0 otherwise.

Pick(Max(CompleteMonth)+1,Sum({< Month = , LastCompleteMonth={1} >} YourKPIField) ,Sum({< CompleteMonth = {1} >} YourKPIField))

We pick one formula: If we have at least one complete month in the data, we sum all the data for the complete months (the second formula). If we have no complete months in the data, we ignore the selection in Month and only sum the data for the last known complete month.

[nyakeyac · Accepted solution]

Thank you for the suggestion. I'll test it out and get back to you. 

A complete month has specific parameters that need to be met. Hopefully I can use those to create a flag and test your formula. 

Thank you