- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Show negative counts in KPI
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.
- Tags:
- qlik sense kpi
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Ram,
look at this:Fabs ‒ QlikView
and this:
https://www.youtube.com/watch?v=K7nO70behkg
i hope that helps
Beck
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
please attach a printscreen and the expected result.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi ram,
I think do like this, In script level write like this,
LOAD ID,
Sal1,
Sal 2,
Sal1-Sal2 as Sal
from tablename;
after write condition in KPI:- count(if(Sal<=0,ID)) you will get answer.
Regards,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Now, it's working