Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I am using the below expression, am getting exact values in table with dimensions in Qliksense.
Result : In table am getting 1,0,-1 values.I want to show the 1,0,-1 values in filter pane then in KPI i need to get count based on values whether it's 1 or 0 or -1.
Expression:
count({<department={"ABC"},Month={">=$(=MonthStart(Max(loadtime)))<=$(=monthend(Max(loadtime)))"}>}distinct resource_id)
-
Count({<department={"ABC"},Month={"$(=monthend(addmonths(max(resource_id),-1)))"}>}distinct resource_id)
Regards,
Aj
Hi Ajay,
So you need to create field in backend and then you can use same expression in KPI. In this way get count based on values.
Thanks
Thanks Usama,
Thats where i stucked. Do you have any idea on this, please let me know.
Regards,
Aj