Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
Hi.
Why dont you use quotes as F and NA are strings ?
Though you use it for asterix.
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 )
curious, what is the tilde prefixing PO_ID for ?
isn't it for exclusion?
great doc here http://community.qlik.com/docs/DOC-4951