How to use a ColumnName as dimension and selection Criteria
I am new to QlikView and not able to figure out the solution.I have a datastructure in the form of columns A,B,C,D,E,2010,2011,2012,2013,2014.
where columns 2010,2011,2012,2013,2014 represent years which have integer sales values corresponding to columns A,B,C,D,E.
I want to build a report where I am able to select year and according the bar chart should display the selected years data on X axis and total sales on Y axis.I also want to multiselect different values for A,B,C,D or E for a particular year so that the bar chart gives me total sales value for selected values.
I am not able to figure put how should I configure the data so that I can use a ColumnName in table as a dimension,for selection and be able o use the column data.