topic column values based on selection in QlikView

column values based on selection

Paulius — Wed, 25 Nov 2020 16:16:04 GMT

hi all,

i have seen in QLik sense, when you can based on value click, and get different values in table columns.

i try to do that in QLikview

so idea is simple, like, i have few columns in table, but sometimes i would like to see only Liters columns, sometimes only gross.

for this i do load inline few values

and instead of expression =sum(Liters)

i would like to have something = sum ( selection from choice table) (assuming that only selection is done in

Re: column values based on selection

Stoyan_Terziev — Fri, 06 Dec 2019 22:03:38 GMT

Hey,

You may want to check this thread:

https://community.qlik.com/t5/Qlik-Design-Blog/Customizable-Straight-Table/ba-p/1464825

Re: column values based on selection

Paulius — Fri, 06 Dec 2019 22:09:18 GMT

thanks,

means, the way i have found, that in pivot table I'm making like 1-4 columns (in real it will be ~10) and then making conditional to show or not - that;s the way.

only i used few dimensions single load inline, and your example is super, all values in one table.

improves my findings .

thanks !