topic Re: Including all items in list as expression to chart(Pivot Table) in QlikView

Including all items in list as expression to chart(Pivot Table)

kamal_sanguri — Thu, 11 Sep 2014 13:37:32 GMT

Hi,

I am trying to create a customized table with user selected fields and expression. But stuck... Is there any way to display all selected items as expression... I do not want to list them individually in expression.. What I am trying to do is I will update the list of expression in excel and once I reload the app it should update the chart with added expression in list.

Any help would be appreciated..

Thanks,

Re: Including all items in list as expression to chart(Pivot Table)

ecolomer — Thu, 11 Sep 2014 13:53:46 GMT

Here you have an example

Re: Including all items in list as expression to chart(Pivot Table)

kamal_sanguri — Thu, 11 Sep 2014 14:11:37 GMT

Thanks for the reply.. I have already tried this and now I am looking for some better way.. I have more than 100 fields for expression and it is very difficult to list all of them and then write function for them.. Also it there is any new field is added.. I have to again include that in the list...

what I am looking for is.. something like this.. _metrics is the header of list

I have done this...

I want to do this...