topic Re: Bar chart Issue - unique ID having multiple values in QlikView

Bar chart Issue - unique ID having multiple values

kkkumar82 — Wed, 03 Dec 2014 14:57:22 GMT

Hi all,

LOAD * INLINE [

Eid, Name, Salary

101, KK, 1000

101, KK, 2000

102, PK, 3000

103, Kis, 4000

104, Har, 5000

];

The above is the data which I am using to create a bar chart dimension as Eid, measure Salary not sum(salary).

As you all know the bar chart will not show 101 dimension value because it doesn't know which salary to consider.

I have a strange requirement that can we show two bars for 101 Eid with 1000 and 2000 values when nothing is selected and 101 Eid is selected.

Thank You

Regards KK

JonnyPoole — Wed, 03 Dec 2014 15:03:03 GMT

dual(Eid,Salary) as the sole dimension (calculated) will do it

kkkumar82 — Wed, 03 Dec 2014 15:11:41 GMT

Thanks a lot Jonathan Poole,

Actually I have a similar kind of situation in my project , I will try this and let you know.

Any way thanks a lot.