I have today's and yesterdays data. If I subtract today's sales with yesterdays data (i.e : for ID 1: 200-300 -> -100, So I need to show the negative count of ID). Showing result perfectly for each row. I need the negative count in KPI.
look at this:Fabs ‒ QlikView
i hope that helps
I need the count of ID which shows the negative value. In this case no. of count is 1, since the ID : 1 has negative value.
I think do like this, In script level write like this,
Sal1-Sal2 as Sal
after write condition in KPI:- count(if(Sal<=0,ID)) you will get answer.
Now, it's working
please attach a printscreen and the expected result.
Retrieving data ...