Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for
Search instead for
Did you mean:
Contributor II

## Multilevel visualisation in QlikView

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

2 Solutions

Accepted Solutions
MVP

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.

Contributor II
Author

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

2 Replies
MVP

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.

Contributor II
Author

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

Community Browser