Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
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
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
Thanks