Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have fields [ID] and [make Vs nonmake].
if i select any more than one or not selected in kpi in my chart it calculate number of ID s available for those KPIs.
i am using the if(Count(Distinct KPI)<>1,Count(distinct [SCML Id]),$(vSiteCountScorecard))
this expression for that.
same way i need to calculate the number of make ID is if not select any kpi or select more than one kpi.
mak vs nomake filed values are make and non make.
i am writing the below expression for that.but not getting the proper value.
if(Count(Distinct KPI)<>1,[make vs nomake]='Make',Count(distinct [ Id]),$(vSiteCountScorecard))
please help on this.
When you have more than one condition to check for in Qlik sense you can combine them with and/or
if(Count(Distinct KPI)<>1 and [make vs nomake]='Make',Count(distinct [ Id]),$(vSiteCountScorecard))
Please check the function getselectedcount() to check if any values are selected in a field or not. Similarly you can check for getfieldseletections() as well and use it wherever necessary.
Thanks
Pradosh
not working .
see the screen short for the reference.
i am select one kpi on that it showing total 151 sites.but make and non make showing wrong value.make is 80 and non make is 71 sites.
You have to check your logic for that .
In first expresion you have calculated Count(distinct [SCML Id]) , in second you are doing count(distinct Id) not sure if this is what you want.
Please check your fields again.