topic Re: Conditional dimension in Line chart :: Qliksense in QlikView

Conditional dimension in Line chart :: Qliksense

chhavi376 — Mon, 18 Dec 2017 07:02:01 GMT

Hi All,

I have a requirement in Qliksense-that is 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

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?

Re: Conditional dimension in Line chart :: Qliksense

Anil_Babu_Samineni — Mon, 18 Dec 2017 07:16:20 GMT

May be suppress Null value from If condition dimension.

Re: Conditional dimension in Line chart :: Qliksense

chhavi376 — Mon, 18 Dec 2017 07:18:34 GMT

I have unchecked 'include null values' in dimension already. there isnt any such option for measure

Re: Conditional dimension in Line chart :: Qliksense

Anil_Babu_Samineni — Mon, 18 Dec 2017 07:20:32 GMT

I don't think this is because of Measure. Even though, Can you check "Appearance" tab for a while in sense

Re: Conditional dimension in Line chart :: Qliksense

chhavi376 — Mon, 18 Dec 2017 07:23:24 GMT

No, nothing there

Re: Conditional dimension in Line chart :: Qliksense

Anil_Babu_Samineni — Mon, 18 Dec 2017 07:35:21 GMT

Why Mouse over shows same with text and data point? do you used Dual() over measure.

Re: Conditional dimension in Line chart :: Qliksense

chhavi376 — Mon, 18 Dec 2017 07:39:53 GMT

No use of dual.

two dim:

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

one meas:

Measure:

if(GetSelectedCount(Status)>0,

Count(distinct measure),

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

that is it