Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

kkkumar82
Valued Contributor III

Bar chart Issue - unique ID having multiple values

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

Tags (3)
1 Solution

Accepted Solutions
Employee
Employee

Re: Bar chart Issue - unique ID having multiple values

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

Capture.PNG.png

View solution in original post

2 Replies
Employee
Employee

Re: Bar chart Issue - unique ID having multiple values

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

Capture.PNG.png

View solution in original post

kkkumar82
Valued Contributor III

Re: Bar chart Issue - unique ID having multiple values

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.