Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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