Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

ignore selection in set analysis into 'Pick(mach(ValueList'

Hi all,

I would like to ignore selections in expressions  that I used in table.

The expression is the following:

=Pick(Match(ValueList('Negotiated','APV','GRN')
,
'Negotiated','APV','GRN'),

Sum ({$<BFTYP= {'ACTUAL'},COMMODITY_SHORT_DESC=, MonthNum={1}>}$(s_ZZPG_FINAL))
,
Sum ({$<BFTYP= {'ACTUAL'},COMMODITY_SHORT_DESC=, MonthNum={1}>}$(s_NETWR))
,
Sum ({$<BFTYP= {'ACTUAL'},COMMODITY_SHORT_DESC=, MonthNum={1}>}$(s_WRBTR))

)


I want that COMMODITY_SHORT_DESC will be ignored. But it doesn't work.


If I use just the set analysis, without Pick(mach(valuelist,  intsted it works:

Sum ({$<BFTYP= {'ACTUAL'},COMMODITY_SHORT_DESC=, MonthNum={1}>}$(s_ZZPG_FINAL))


Can you help me?


Thank you,

Silvia



3 Replies

Re: ignore selection in set analysis into 'Pick(mach(ValueList'

Please share a small example.

- Marcus

Not applicable

Re: ignore selection in set analysis into 'Pick(mach(ValueList'

Hi Marcus,

I've attached an example.

if you click on one Commodity, one table works and the other one doesn't works.

Thank you

Silvia

Re: ignore selection in set analysis into 'Pick(mach(ValueList'

The behaviour of the application is odd and I would make a backup of them and then create a new one from the scratch (not copy + paste of the objects). And in this new app I wouldn't use any trigger (it's quite the same like: Macros are Bad) and if then only there where it's really mandatory and this implementing as the last step of the development.

Beside them I suggest to consider a change to the data-model. Your fact-table looked like a big cross-table and I'm not sure if it's a good way to use these calculated dimensions. I think it would be better to solve this within the script. Maybe this is a starting point for you: The Crosstable Load.

- Marcus

Community Browser