Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

pivot table

Hi,

I have a set of data which looks like

email address, group, question, option, answer

eg.

x@hotmail.com,'G1','Q1','Opt1','Y'

x@hotmail.com,'G1','Q1','Opt2','N'

x@hotmail.com,'G1','Q2','Opt1','N'

x@hotmail.com,'G2','Q1','Opt1','Y'

x@hotmail.com,'G2','Q1','Opt2','Y'

x@hotmail.com,'G2','Q1','Opt3','N'

x@hotmail.com,'G2','Q2','Opt1','Y'

x@hotmail.com,'G2','Q2','Opt2','N'

etc

so for each email, there are many groups, for each group, there are many questions, for each questions there are many options and for each options there is an answer

I have normalised this table so I have a Group table of distinct Groups, a Question table of distinct questions for each Group and an Option table of disitinct options for each Group/Question.

I would like to have distinct Pivot tables in QlikView for each Group using this data - is that possible given the above structures where the Dimensions on each Pivot are Question and Option?

Tags (1)
2 Replies
Not applicable

pivot table

Yes,

If your model is correctly setup you'll be able to select what you want so that dimensions and expressions will be calculated accordingly to your Selection.

I don't know if this answer your question, i hope it help you.

rgds

MVP
MVP

pivot table

You can create calculated dimensions limiting your Questions to the desired Group:

=IF(Group = 'MyGroup', Question)

and check "Suppress when value is null" - this way, only questions for the specific Group will be included in the Pivot Table.

This would work well if your dataset is not huge - otherwise, you might have to look for another solution...

cheers,

Community Browser