Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

Drill down happening if there is no data in previous Year

Hi all,

I have a problem in drill down in pie chart.I have 2 fact table sales and price.Sales has data of 2019,2020,2021,but price table has value for only 2021.In drill dimension I have 2 fields one from price table and other from master table (Item master).Problem arises when I filter the year  2020 .It automatically drill down  from price dimension to  item master dimension.

It drill dimension should not  change  even if I select year  or any other date filter.

I appreciate  if anybody helps .Thanks in advance.

Labels (1)
3 Replies
Contributor III
Contributor III

Hi,

Try to nullify the fields in expression on which you dont want the chart to change.

like this : Sum({<Year=,Month=,Quarter=>}Sales)

Regards,

Prashant

Creator
Creator

Dear prashant, I tired nullify the All the Fields though not working .

Creator III
Creator III

hi,

Introduce master calendar,

it will work,

ksrinivasan.