topic Re: Dynamic table based on user selection in QlikView

Dynamic table based on user selection

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

Hello,

I have multiple expressions.

No of Orders
Total quantity
Total Order Amount
Avg Quantity
Avg Order Amount

I need to add a table which shows either [NO of Orders, Total Qty, Total Order Amount] or [No of Orders, Avg Quantity, Avg Order Amount]. What is the best way to do it ?

Thank you,

Re: Dynamic table based on user selection

sunny_talwar — Wed, 12 Oct 2016 18:16:40 GMT

Check this link may be:

Customizable Straight Table

Re: Dynamic table based on user selection

johnw — Thu, 13 Oct 2016 00:08:20 GMT

If all you're doing here is selecting what kind of aggregation to do, maybe a list box for field Aggregation with values Total and Average, where you must and can only select one value. Then expressions like if([Aggregation]='Average',avg(Quantity),sum(Quantity)). There are arguably more elegant ways, like defining your expressions in script, but I can see myself just doing that simple if() and moving on if there are only a few fields and only a couple choices.

If you want more dynamic capability, stalwar1's link is very close to how I do dynamic charting.