topic Re: Set analiysis explanation in QlikView

Set analiysis explanation

Tue, 15 Dec 2015 11:56:54 GMT

Please can someone add set analysis to this

expression so that NO other selections change the result.

=count(if(DayDiff>0,SCO_No))

Can you also explain what each part of this goes and what it does...

Thank you for previous examples but unsure on this one.

ie: > { etc.

Thank you

miguelbraga — Tue, 15 Dec 2015 12:01:15 GMT

Hi Emma,

You can make a field like this in the table where have the field [DayDif]:

if(DayDif>0, 1, 0) as FlagDayDif

Then you can make a set analysis like this:

=count({$<FlagDayDif = {"1"}>} SCO_No)

Hope this helps

Regards,

avinashelite — Tue, 15 Dec 2015 12:02:59 GMT

try like this :

=count({1<SCO_No={"=if(DayDiff>0,SCO_No)"}>}SCO_No)

there 1 will count it for the whole set and will not vary on the current selection

" " double quotes is for the evaluation of your expression

miguelbraga — Tue, 15 Dec 2015 12:03:33 GMT

This expression only counts when the value of the FlagDayDif is 1. The only way the FlagDayDif is 1 is when DayDif is greater than zero

amit_saini — Tue, 15 Dec 2015 12:04:28 GMT

Emma,

You can do like this:

=count({$<DayDif = {">0”}>} SCO_No)

Thanks,
AS

sunny_talwar — Tue, 15 Dec 2015 12:05:02 GMT

Try this:

=Count({1<DayDiff = {'>0'}>} SCO_No)

jonathandienst — Tue, 15 Dec 2015 12:07:51 GMT

If you want to ignore all selections, then you can simply add {1} to the expression:

=count({1} if(DayDiff>0,SCO_No))