topic Re: qlik app eval: how to filter data in Integration, Extension & APIs

qlik app eval: how to filter data

matteoredaelli — Fri, 05 Jan 2024 13:12:53 GMT

Reading the documentation https://qlik.dev/toolkits/qlik-cli/app/app-eval/ I was able to query the monitoring app Entitle ANalyzer

qlik app eval "sum(duration)" "min(endTime)" "max(endTime)" "sum(capacityUsed)" "count(userSubject)" by userSubject Entitlement_Assigned -a $APPID

but I did not find how to filter data, for example extracting data after a specific date...

Is it possibile using qlik cli?

Thanks in advance

Matteo

Re: qlik app eval: how to filter data

timow — Sun, 14 Apr 2024 17:23:31 GMT

It's possible to filter data using Set expressions in measures. For example something like this might work:

qlik app eval "sum({<UsageMonthText={'Apr 2024'}>}duration)" "min({<UsageMonthText={'Apr 2024'}>}endTime)" "max({<UsageMonthText={'Apr 2024'}>}endTime)" "sum({<UsageMonthText={'Apr 2024'}>}capacityUsed)" "count({<UsageMonthText={'Apr 2024'}>}userSubject)" by consumerName Entitlement_Assigned -a $APPID