topic Re: Help need with alternate state in QlikView

Help need with alternate state

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

sunny_talwar — Mon, 08 Aug 2016 16:12:29 GMT

May be this:

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

vishsaggi — Mon, 08 Aug 2016 16:14:35 GMT

May be try this:

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

Anonymous — Tue, 09 Aug 2016 07:47:26 GMT

Thanks Vish &é Sunny,

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

Have a nice day

Jegadish