Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cancel
Showing results for 
Search instead for 
Did you mean: 
ajaykumar1
Creator III
Creator III

Converting set analysis as variable

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

2 Replies
Usama
Creator
Creator

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

From Nothing - To Something - To Everything
ajaykumar1
Creator III
Creator III
Author

Thanks Usama,

Thats where i stucked. Do you have any idea on this, please let me know.

Regards,

Aj