topic Re: Count on if condition in QlikView

Count on if condition

Anonymous — Thu, 12 Jul 2018 07:58:34 GMT

Please refer the table below:

I want an expression to count number if all the values design_accept=3.

Eg; If all the values for design_accept=3 for each MachDateKey then it should count as 1.

Please assist.

Re: Count on if condition

arvind_patil — Thu, 12 Jul 2018 08:09:56 GMT

Hi Mohammed,

Your expression like below:

Count({<design_accept={'3'}>}MachDateKey)

Thanks,

Arvind Patil

Re: Count on if condition

Anonymous — Thu, 12 Jul 2018 08:16:15 GMT

Hi Arvind,

I am unable to get the desired result with the above expression.

I am aware of this expression and have used it already (Count({<design_accept={'3'}>} distinct MachDateKey) ) but even though sometimes not all values are equal to 3 , it is taking count for that MachDateKey.

So I need some count function which includes avg expression inside IF condition.

Re: Count on if condition

arvind_patil — Thu, 12 Jul 2018 08:23:25 GMT

O Got it.

write it on script level:

if(match (design_accept,'3') and not is null(MachDateKey) ,1,0) as Count3rd,

And in front end expression :

count (distinct Count3rd)

Thanks,

Arvind Patil

Re: Count on if condition

Anonymous — Thu, 12 Jul 2018 10:17:24 GMT

Not working..

Syntax error I guess

Re: Count on if condition

sunny_talwar — Thu, 12 Jul 2018 10:19:56 GMT

How about this

Count({<MachDateKey = {"=design_accept = 3"}>} DISTINCT MachDateKey)

Re: Count on if condition

rubenmarin — Thu, 12 Jul 2018 10:22:59 GMT

Hi nMohammed, you can try with:

=Count(DISTINCT {<MachDateKey{"=Max(design_accept)=3 and Min(design_accept)=3"}>} MachDateKey)

Re: Count on if condition

Anonymous — Thu, 12 Jul 2018 10:38:09 GMT

Thank you all for the help...

Re: Count on if condition

Anonymous — Tue, 14 Aug 2018 13:20:19 GMT

What changes do i need to write in the above set analysis expressions if I bring in one more field called "Date" which has only two unique values ?

Assume max date and min date.

Re: Count on if condition

sunny_talwar — Tue, 14 Aug 2018 19:33:35 GMT

Not sure I understand, what do you mean 2 unique values for the Date field? Can you elaborate with an example?

Re: Count on if condition

Anonymous — Thu, 16 Aug 2018 08:10:20 GMT

Assume I have two data sets 'X' and 'Y' of two different weeks.

X being the current week and Y being the previous week which had Date field storing two different dates.

I have declared two variables vMaxDate=Max(Date) and vMinDate=Min(Date).

I want to use these variables in the above set analysis expression for counting the same field.

What modifications should I do to the above set analysis expressions given as correct for this post ?

Re: Count on if condition

Anonymous — Thu, 16 Aug 2018 09:42:27 GMT

For this expression : Count({<MachDateKey = {"=design_accept = 3"}>} DISTINCT MachDateKey)

Re: Count on if condition

sunny_talwar — Thu, 16 Aug 2018 11:14:17 GMT

Assume I have ...

Sample works much better then Assuming

Re: Count on if condition

Anonymous — Fri, 28 Sep 2018 11:57:27 GMT

This expression is working weird for me.

It's giving the correct output at one point and then again when I reload new data, it's giving wrong output.

I am unable to follow the syntax of this set analysis expression.

Please assist.

Re: Count on if condition

sunny_talwar — Sat, 29 Sep 2018 15:17:02 GMT

Can you provide a sample to show where this isn't working?