topic Re: Ignoring selections in set analysis in QlikView

Ignoring selections in set analysis

Gopi_E — Sat, 16 Nov 2024 01:38:19 GMT

Hi All,

here i trying to ignore one field selection in set analysis, but still its taking selection from that field, here is my metrics

Sum({$<Month = {"$(='>=1<='& max(MonthNum))"}, Year = {"$(='>=2011<='& max(Year))"}, YearMonth= ,MonthNum=>}Sales)

above one taking selections from YearMonth and MonthNum fields,

can you please let me know what is wrong this expression

Thanks in advance

Re: Ignoring selections in set analysis

Arthur_Fong — Tue, 24 Dec 2019 10:03:21 GMT

Try this:

Sum({$<Month = {"$(='>=1<='& max({1}MonthNum))"}, Year = {"$(='>=2011<='& max(Year))"}, YearMonth= ,MonthNum=>}Sales)

Re: Ignoring selections in set analysis

Gopi_E — Tue, 24 Dec 2019 10:29:26 GMT

Hi Arthur_Fong,

Thanks for the reply,

it's working as i expected, thank you

Re: Ignoring selections in set analysis

Anil_Babu_Samineni — Tue, 24 Dec 2019 10:25:32 GMT

@Gopi_E Perhaps this

Sum({$<Month = {"$(='>=1<='& max({<MonthNum, YearMonth>} MonthNum))"}, Year = {"$(='>=2011<='& max({<MonthNum, YearMonth>} Year))"}, YearMonth= ,MonthNum=>}Sales)