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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Aspiring_Developer
Specialist
Specialist

Values changing to 100 % on dimension selection

Hello ALL,

I have created  a mekko chart using vizlib extension in qliksense using below dimension and measure:-

Dim - Brand | Dimension

Measure - Sum({<Category={'Price Range'},NumMonth={"$(=num(addmonths(max((NumMonth)),-12)))"}>} Volume)

Now when I am making selection on brand filter , my values are changing to 100 % like below :-

 

Aspiring_Developer_0-1662984738927.png

 

 

Below are the  values inside my dimensions :-

Aspiring_Developer_1-1662984738923.png

 

I don't want my values to change to 100 %. If I making a selection on specific brand , it should give a particular value :-

For price range - 0to 200 . So , on selection of brand as BT , the value should be 21 % and should not change to 100 %.

Aspiring_Developer_2-1662984767254.png

Can anyone please help ?

Thanks in advance

Labels (1)
0 Replies