Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Announcements

Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET:
**REGISTER NOW**

- Qlik Community
- :
- All Forums
- :
- QlikView App Dev
- :
- Re: Multilevel visualisation in QlikView

Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

nyakeyac

Contributor II

2021-03-03
10:19 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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

483 Views

2 Solutions

Accepted Solutions

Or

MVP

2021-03-04
05:03 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.

452 Views

nyakeyac

Contributor II

2021-03-07
04:36 PM

Author

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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

442 Views

2 Replies

Or

MVP

2021-03-04
05:03 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.

453 Views

nyakeyac

Contributor II

2021-03-07
04:36 PM

Author

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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

443 Views