topic Re: Create straight table in QlikView script in QlikView

Create straight table in QlikView script

Mon, 28 Jul 2014 19:37:31 GMT

I want to take this:

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

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?

Re: Create straight table in QlikView script

joshabbott — Mon, 28 Jul 2014 19:49:26 GMT

It looks like that table already exists in your script. Let's pretend it is called Table1:

Try something like this in your script:

Load

YearEventKey as YearEventKey_Grouping

, count(ID) as CountOfEach
Resident

Table1
GROUP

YearEventKey;

This should create a table in your script with the YearEventKey_Grouping column, then a count column (CountOfEach)

Re: Create straight table in QlikView script

Mon, 28 Jul 2014 20:04:08 GMT

Amazing. It Worked perfectly. Thank you very much. For some reason I didn’t think of counting inside the load script. Much Appreciated.