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: 
prashantsanchet
Creator
Creator

KPI value not changing having set analysis in it

Hi Team,

I want to count the strategy but ignoring the strategy if values in variable vSales is zero.

I have written following expression in KPI Object:

count(distinct([Strategy.])) - count({<[Strategy.StrategyDescription] ={"=$(vSales)=0"} >} distinct [StrategyDescription])



i have one bar chart where i have strategy as dimention and vSales as measure and we are hiding zero values.

i have one filter as "vSelection" having different value as Q1,Q2,Q3;

Based on this selection i am calculating vsales variable value i.e if ( $(vSelection)='Q1, 'X'if ( $(vSelection)='Q2, 'Y','Z'))



But when i am comparing strategy count in KPI and chart are not matching if we change "vSelection" filter.


could you please suggest solution asap

1 Reply
sunny_talwar

May be you need this

Sum(Aggr(Count(DISTINCT [Strategy.]) - Count({<[Strategy.StrategyDescription] = {"=$(vSales)=0"} >} DISTINCT [StrategyDescription]), strategy))