Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 3 columns in my data: Year, Member and Count.
I want a table with year as the dimension and a column for each member with the count per year as my value. How do I do this?
Essentially, I could have my measure be: if Member = MemberA, sum count for member. But that would be tedious and members change year over year, so I really need to dynamically create my columns. Any help with this would be much appreciated.
Hi,
you can use a pivot table with year and members as dimensions, year as rows, and members as columns.
Then your expression will be simple: sum(count)
Hi,
you can use a pivot table with year and members as dimensions, year as rows, and members as columns.
Then your expression will be simple: sum(count)
Thank you. Maybe I was trying to use the Vizlib Pivot? It's nesting the member under the program year. I think I assumed the Qlik Pivot would do the same. But I just tried that and it worked exactly as I wanted with my members as column names!
Another question though, it doesn't download as that table. It downloads as a 3 column table with my 2 dimensions and the sum - as a straight table and not pivoted. Any ideas how to get it to retain the original structure on export?