topic Re: set analysis didn't work in QlikView

set analysis didn't work

yelin_nyu — Sun, 25 Aug 2013 12:31:35 GMT

i used

sum({$<FORECAST_YEAR={'$(=vSelectedYear)'}, FORECAST_TYPE_ID={"*"}-{F}, REGION_ID=>} $(vValue))

but FORECAST_TYPE_ID={"*"}-{F} didn't work, i still get values when i select F. but this worked FORECAST_TYPE_ID-={F} with ugly red line. why first case didn't work?

i had a similar expression

sum({$<FORECAST_YEAR={'$(=vSelectedYear)'}, REGION_ID={'*'}-{NA}>}qty)

and REGION_ID={'*'}-{NA} worked great.

there is sync keys in my tables, but it's not related to FORECAST_TYPE_ID. what can possibly cause this set analysis equation to fail?

Re: set analysis didn't work

yelin_nyu — Sun, 25 Aug 2013 13:16:23 GMT

ok i sort of figured out the problem. so when i select on forecast type id F, it still give me a value when forecast type id F is excluded. very interesting because i thought it should go to 0

Re: set analysis didn't work

whiteline — Sun, 25 Aug 2013 17:11:55 GMT

Hi.

Why dont you use quotes as F and NA are strings ?

Though you use it for asterix.

Re: set analysis didn't work

yelin_nyu — Wed, 06 Nov 2013 01:31:04 GMT

a follow up question. trying to understand the difference here

this worked:

count(DISTINCT {$<PO_ID = {"*"} - {"33*"} - {"55*"}>} ITEM_ID )
so is this:

count(DISTINCT if(PO_ID like '33*' or PO_ID like '55*', null(), ITEM_ID))

but this didn't, why? is my syntax wrong

count(DISTINCT {$<~PO_ID = {"33*","55*"}>} ITEM_ID )

Re: set analysis didn't work

paul_scotchford — Wed, 06 Nov 2013 01:50:18 GMT

curious, what is the tilde prefixing PO_ID for ?

Re: set analysis didn't work

yelin_nyu — Wed, 06 Nov 2013 01:55:04 GMT

isn't it for exclusion?

Re: set analysis didn't work

paul_scotchford — Wed, 06 Nov 2013 02:07:56 GMT

great doc here http://community.qlik.com/docs/DOC-4951