Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
matteoredaelli
Contributor III
Contributor III

qlik app eval: how to filter data

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

Labels (3)
1 Reply
timow
Employee
Employee

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