Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
apegahfar
Contributor III
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

1 Solution

Accepted Solutions
apegahfar
Contributor III
Contributor III
Author

I find the correct answer . it works well

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

View solution in original post

5 Replies
pathiqvd
Creator III
Creator III

Hi,

Try This,

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


Regards.

arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Amirhossein,

Please try below:


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


Thanks,

Arvind Patil

apegahfar
Contributor III
Contributor III
Author

Dear lakshmipathi p                   

thank for your reply

unfortunately it didnt work

apegahfar
Contributor III
Contributor III
Author

Dear Arvind Patil

thank for your reply

unfortunately it didnt work

regard

apegahfar
Contributor III
Contributor III
Author

I find the correct answer . it works well

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