Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
chhavi376
Creator II
Creator II

Conditional Dimension in Line Chart

Hi All,

I have a requirement is which if i want lines corresponding to the selected statuses from the filter and if only no status is selected then only one line correspond to 'ongoing' status should be displayed.

Dimension used:

IF(GETSELECTEDCOUNT(Status)>0,Status,'Ongoing')

Measure:

if(GetSelectedCount(Status)>0,

Count(distinct measure),

Count({<Status={'Ongoing'} >}distinct measure))

But i am getting a weird behaviour here. If i select values in status, 'ongoing' line is also displayed with values as 0.

it should not appear at all

community.png

Can we in any case make the2 dimensions- one for ongoing and other for all the values of status and make them conditional? like one dimension works if getselectedcount is 0 and one works when it is not .(This was easily possible in qlikview)

Can someone help?

1 Reply
sunny_talwar

Might be easy to see this behavior in a sample to test this out... would you be able to share one?