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

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...

 

QFabian

View solution in original post

2 Replies
QFabian
Specialist III
Specialist III

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...

 

QFabian
Qlik_1
Contributor
Contributor
Author

Thanks