Is there anyway to pivot the data in qlikview at chart level instead of script level.
I want to display a chart with column headers as dimensions and the value of columns as expression. I know I can manage this by using CrossTable function in qlikview. But I do not want to disturb my data model by using CrossTable as it will impact other charts. I have around 65 charts that can get affected.
I thus want a mechanism to pivot down the structure at chart level so that I can use the existing data model by not affecting existing charts.
