Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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