Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Pivot tables

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.

5 Replies
jsn
Honored Contributor

Pivot tables

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

Not applicable

Pivot tables

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

Pivot tables

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

Pivot tables

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

Pivot tables

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

thank you for all the help!

Community Browser