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: 
Qlik_1
Contributor
Contributor

Qlik Expression Understanding

Hi,

Can anyone help me in understanding the following expression?

please explain the following expression. 

 (sum({$<[Snapshot Type]={'Last weekday'},[Overdue Group]={'Patients Due'}, [Record Type]={'Daily Snapshots'}>} Patients))

Labels (5)
1 Solution

Accepted Solutions
QFabian
MVP
MVP

Hi @Qlik_1 ,  greetings! your expression can be interpreted like this :

sum(
{$<[Snapshot Type]={'Last weekday'} , [Overdue Group]={'Patients Due'} , [Record Type]={'Daily Snapshots'}>}
Patients)

Sum the content of the field 'Patients', considering the current selections, but, in the field [Snapshot Type] consider the value 'Last weekday' as the filter and for the field [Overdue Group] consider the value 'Patients Due' as the filter and for the field [Record Type] consider the value 'Daily Snapshots' as the filter

 

Qlik Help

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAnalys...

 

Greetings!! Fabián Quezada (QFabian)
did it work for you? give like and mark the solution as accepted.

View solution in original post

2 Replies
QFabian
MVP
MVP

Hi @Qlik_1 ,  greetings! your expression can be interpreted like this :

sum(
{$<[Snapshot Type]={'Last weekday'} , [Overdue Group]={'Patients Due'} , [Record Type]={'Daily Snapshots'}>}
Patients)

Sum the content of the field 'Patients', considering the current selections, but, in the field [Snapshot Type] consider the value 'Last weekday' as the filter and for the field [Overdue Group] consider the value 'Patients Due' as the filter and for the field [Record Type] consider the value 'Daily Snapshots' as the filter

 

Qlik Help

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAnalys...

 

Greetings!! Fabián Quezada (QFabian)
did it work for you? give like and mark the solution as accepted.
Qlik_1
Contributor
Contributor
Author

Thanks