Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
apegahfar
New Contributor III

Set analysis help

Hi Community,

I am trying to use below function as expression in a straight table

=Count({<PeriodCode={$(=FieldValue('PeriodCode',FieldIndex('Period',GetFieldSelections(Period)))-1)}>}Period)

but it doesnt work

however without '-1' it works

please help

regards

Tags (1)
1 Solution

Accepted Solutions
apegahfar
New Contributor III

Re: Set analysis help

I find the correct answer . it works well

=Count({<Period,PeriodCode={$(=FieldValue('PeriodCode',FieldIndex('Period',GetFieldSelections(Period)))-1)}>}Period)

5 Replies
pathiqvd
Contributor III

Re: Set analysis help

Hi,

Try This,

=Count({<PeriodCode={"=FieldValue('PeriodCode',FieldIndex('Period',GetFieldSelections(Period)))-1"}>}Period)


Regards.

Partner
Partner

Re: Set analysis help

Hi Amirhossein,

Please try below:


=Count({<PeriodCode={$(=FieldValue('PeriodCode',FieldIndex('Period',GetFieldSelections(Period)),-1))}>}Period)


Thanks,

Arvind Patil

apegahfar
New Contributor III

Re: Set analysis help

Dear lakshmipathi p                   

thank for your reply

unfortunately it didnt work

apegahfar
New Contributor III

Re: Set analysis help

Dear Arvind Patil

thank for your reply

unfortunately it didnt work

regard

apegahfar
New Contributor III

Re: Set analysis help

I find the correct answer . it works well

=Count({<Period,PeriodCode={$(=FieldValue('PeriodCode',FieldIndex('Period',GetFieldSelections(Period)))-1)}>}Period)