Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot tables

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!

1 Solution

Accepted Solutions
Not applicable
Author

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.

View solution in original post

5 Replies
Anonymous
Not applicable
Author

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

Not applicable
Author

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.

Not applicable
Author

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.

Not applicable
Author

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.

Not applicable
Author

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

thank you for all the help!