topic Pivot tables in QlikView

Pivot tables

Tue, 28 Jun 2011 21:40:20 GMT

I have a table with username, time, frequency of queries run by that user.

Now, when i click on frequency, i want all the queries to be displayed.

How can i do this? Is pivot table the correct approach?

Thanks!

Anonymous — Tue, 28 Jun 2011 22:32:53 GMT

It's not quite clear what you mean here. Please ellaborate on the question

Tue, 28 Jun 2011 22:38:16 GMT

So i already have a table with 2 columns containing the user name and the frequency (of times the user has run a query).

Now i want to add another column to the table. This column should drill into the frequency and show all the individual queries run.

So for example, if someone has a frequncy of 10, then if we drill down into tht frequency, it should show 10 different queries.

Tue, 28 Jun 2011 22:38:57 GMT

If you use a pivot table you could have the querries in a collapsed dimension so you would either be able to see all of them or a summary.

Tue, 28 Jun 2011 22:41:52 GMT

yeah thts right, but how do i add the 10 queries? it doesnt seem to work in a pivot table.. or im doing something wrong.

Tue, 28 Jun 2011 22:47:11 GMT

OK i just got it! I was implementing it wrong!

thank you for all the help!