Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

display no data display if no data

I have chart with drill down week,date, etc, if i click on previous month button it should display previous month data with week as frst level dimension, it works but when data is not available for previous month it should display no data display instead it shows date as frst level, which is wrong, could you please help me resolving this

1 Solution

Accepted Solutions
sundarakumar
Specialist II
Specialist II

1.Here is a sample where I have replaced Group with two charts. Navigation bw two charts should be with the button.

2. Ideally When there is no data in a a higher drill group, Qlikview will itself show the dimension where data is avialable. This is expected behaviour, if you dont have data at the higher level ther should not be data avaialble at lower levels.

"Group" here is not created in such a way. Group has current month data in first level and all date in second level. this is the problem here. I Have also changed the group to show only dates of this month on date level too. Now as expected it will show "no data to display".

Hope this helps.

-Sundar

View solution in original post

4 Replies
sunny_talwar

Can you share some screenshots showing the issue?

gautik92
Specialist III
Specialist III

post some sample data so that it will b easy to help you

Not applicable
Author

Hi , please find sample doc, when i click on current month it should show only current month data,

but for my case current mnth not available, so it is displaying all the date, but i want no data display in case no data for current month

sundarakumar
Specialist II
Specialist II

1.Here is a sample where I have replaced Group with two charts. Navigation bw two charts should be with the button.

2. Ideally When there is no data in a a higher drill group, Qlikview will itself show the dimension where data is avialable. This is expected behaviour, if you dont have data at the higher level ther should not be data avaialble at lower levels.

"Group" here is not created in such a way. Group has current month data in first level and all date in second level. this is the problem here. I Have also changed the group to show only dates of this month on date level too. Now as expected it will show "no data to display".

Hope this helps.

-Sundar