0 Replies Latest reply: Apr 17, 2012 4:06 PM by Sven Flock RSS

    Use data from Pivot chart for bar chart

      Hi all,

       

      I am new to QlikView. So far, I am very impressed what is possible with this tool. However, I am now stuck with a problem which solution I have not found in the community (I do not know the exact QlikView words to describe it). I think there is a solution, so here is the problem ;-):

       

      My database consist of several tables which are linked through synthetic keys. Due to several n:m relations my total data has about 1 million rows. Based on that set, I create an chart objects with two dimensions and several calculated expressions. Each expression uses the aggr function, i.e.

       

      • Calculated expression 1: AGGR function 1
      • Calculated expression 2: AGGR function 2
      • Calculated expression 3: AGGR function 3
      • Calculated expression 4: AGGR function 4
      • Calculated expression 5: function of all above expression (note that I do not repeat the calculation but use the synonyms because expression 5 is the latest one and all other have been already calculated before.

       

       

      In the next step, I want to create a hisogramm (using the bar chart) based on the above pivot chart. But that's the problem. I have no idea how to do this. Is there a way to input the results of above chart into a new one?

       

      So, temporary I have done the following:

      I have created a new chart. Within that chart I use an calculated dimension which gives the same result as the calculated expression 5 (enrichted with the CLASS function for histogram) from above chart. Next, I add an counter.But QlikView must calculate all data again, i.e. in the first chart and now in the bar chart. Because the aggregations are very complex QlikView uses a lot or RAM and my application is now very slow.

       

      Many thanks!

      Sven