I am new to QlikView and as a part of my report development, I am trying to sort the trellis charts by different expression values. The users have been provided with a "Sort By" listbox where they have all the metrics listed down by which the trellis chart can be sorted.
I am able to achieve this functionality by keeping the metrics (to be plotted) in a pivoted down table.However, our business users mentioned that this can be done by keeping the metrics in columns in the back-end table and using 'Variables' in QlikView. Has anybody tried using variables in the sort option in trellis chart in QlikView ?
