topic Re: How to solve repeating values in bar chart in QlikView

How to solve repeating values in bar chart

abc_18 — Wed, 06 Dec 2017 05:01:25 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 dimension in graph, but for other segments values are repeating for all the Division's IP .

Please suggest.

Re: How to solve repeating values in bar chart

Anil_Babu_Samineni — Wed, 06 Dec 2017 05:10:23 GMT

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

Will you change to highlight one

Re: How to solve repeating values in bar chart

abc_18 — Wed, 06 Dec 2017 05:30:40 GMT

Hi Anil,

I have already tried this, but getting same issue.