Discussion board where members can get started with QlikView.
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?
Go to Solution.
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.
It's not quite clear what you mean here. Please ellaborate on the question
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.
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.
OK i just got it! I was implementing it wrong!
thank you for all the help!