1 Reply Latest reply: Jan 18, 2018 6:11 AM by Sunny Talwar RSS

    KPI value not changing having set analysis in it

    Prashant Sancheti

      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