topic Re: Converting set analysis as variable in App Development

Converting set analysis as variable

ajaykumar1 — Mon, 17 Aug 2020 15:42:38 GMT

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,

Re: Converting set analysis as variable

Usama — Mon, 17 Aug 2020 16:15:37 GMT

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

Re: Converting set analysis as variable

ajaykumar1 — Mon, 17 Aug 2020 16:22:07 GMT

Thanks Usama,

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

Regards,