5 Replies Latest reply: Apr 26, 2011 7:59 PM by John Witherspoon RSS

    Create a pivot/summary table in script?

    Kelly Korynta

      Hello,

      Here's the table I created in excel that I am trying to replicate the format in qlikview:

       

      Here's what I have in Qlikview so far:

      As you can see, I'm able to use objects as a means of getting those values. My dilemma is, I need to use these frequency values to run other sets of analysis (such as creating a scatter plot charts displaying leads created vs 0 to 30 days). Is there a way to replicate this effect in the script? Perhaps the other approach would be to reference to the column in the object?

       

      Thanks