Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
pascaldijkshoor
Creator
Creator

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
sunny_talwar

May be this

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

View solution in original post

2 Replies
sunny_talwar

May be this

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

pascaldijkshoor
Creator
Creator
Author

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