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: 
abc_18
Creator II
Creator II

How to solve repeating values in bar chart

Hi,

In my dashboard I have a bar chart with drill down dimension and two measures.

Dimensions are-  segment IP+Division IP+BU IP+TC IP

And measures are

IP mapped-   sum({<bkey_account=-{'Not mapped'},[Order family]={'XYZ'}>}[Installed product count])

IP Not mapped-  sum({<bkey_account={'Not mapped'},[Order family]={'XYZ'}>}[Installed product count])


Segment IP's are-

DE Science
DE Medical
DE Paed

For  BD Science (Segment IP), I am getting correct values for all the division IP's dimension in graph, but for other segments values are repeating for all the Division's IP .

Please suggest.

2 Replies
Anil_Babu_Samineni

IP mapped-  sum({<bkey_account -= {'Not mapped'},[Order family]={'XYZ'}>}[Installed product count])

Will you change to highlight one

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
abc_18
Creator II
Creator II
Author

Hi Anil,

I have already tried this, but getting same issue.