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: 
Anonymous
Not applicable

Help need with alternate state

Hi all,

I have created two alternate states

GROUPE1

& GROUPE2

i wanted to count the number of days selected in group1

It works well

Count(DISTINCT{[Groupe1]* $} JOUR_ID)

Now with the same selection, i wanted to find the number of days with a flag

count(DISTINCT{<FLAG = {'COMP'}, [Groupe1]* $}>}JOUR_ID)

It is not working, can any one give me an hint plz.

Thanks in advance

Jegadish

1 Solution

Accepted Solutions
sunny_talwar

May be this:

Count(DISTINCT{$ * [Groupe1]<FLAG = {'COMP'}>}JOUR_ID)

View solution in original post

3 Replies
sunny_talwar

May be this:

Count(DISTINCT{$ * [Groupe1]<FLAG = {'COMP'}>}JOUR_ID)

vishsaggi
Champion III
Champion III

May be try this:

= Count(DISTINCT {[Groupe1]* $ <FLAG = {'COMP'} > } JOUR_ID)

Anonymous
Not applicable
Author

Thanks Vish &é Sunny,

It worked, I have another question, will be back again with a question.

Have a nice day

Jegadish