2 Replies Latest reply: Jul 28, 2014 4:04 PM by Joe Crane RSS

    Create straight table in QlikView script

    Joe Crane

      I want to take this:

       

      id.png

       

      and count each respective distinct key, per key in the YearEventKey table, in a separate table... like this straight table output:

       

      key.png

      but I want to do it in the script. I need to be able to add this information to another table while the script is run. Is there a way I can get the distinct keys counted like the straight table but without having to export it as excel and re-import it?