How to solve duplicate data issue in bar graph

Anonymous — Tue, 05 Dec 2017 10:36:20 GMT

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 in graph, but for other segments values are repeating for all the Diviosion's IP .

Please suggest.

topic How to solve duplicate data issue in bar graph in QlikView

How to solve duplicate data issue in bar graph