Qlik Community

Qlik Sense App Development

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

pascaldijkshoor
Contributor

Use multiple identifiers in set analysis

Hi Everyone,

I want to use multiple identifiers in set analysis.

I am currently using the following formula:

Count ({$<tsrm65={'creation of file manually','dossier aangemaakt handmatig'},[tsacdt.autoCalendar.WeeksAgo]={'1'}>}tsttkd)

I am using a bookmark with a selection on L_BEGIN_DATE in this application that has to be used on every chart except this one. So i want to ignore the selection in the formula. Only i don't know how to write two identifiers in one formula. This would be the formula if '1' was the only identifier:

Count ({1<L_BEGIN_DATE>}tsttkd)


Can someone tell me how to combine both identifiers?

Thanks in advance.

1 Solution

Accepted Solutions

Re: Use multiple identifiers in set analysis

May be this

Count({$<tsrm65 = {'creation of file manually', 'dossier aangemaakt handmatig'}, [tsacdt.autoCalendar.WeeksAgo] = {'1'}, L_BEGIN_DATE>} tsttkd)

2 Replies

Re: Use multiple identifiers in set analysis

May be this

Count({$<tsrm65 = {'creation of file manually', 'dossier aangemaakt handmatig'}, [tsacdt.autoCalendar.WeeksAgo] = {'1'}, L_BEGIN_DATE>} tsttkd)

pascaldijkshoor
Contributor

Re: Use multiple identifiers in set analysis

Haha I knew it was something simple. Thanks Sunny, this works fine!

Community Browser