Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

xiyuzw1113
New Contributor III

Dimension problem

Hi all, I have a problem which bothering me for ages. My original table was listed below:

Capture 1.PNG

The "Question no" column including all question number, accordingly "Question content" column is the content.

Continuing with the previous problem. For question no 12 to 15,  the contents of each question is text, I want to show each question's answer according to the selection of question no(12- 15). The first idea is creating a filter pane and then creating a table to display the contents. But for table, it was asked to built the table with dimensions and measures. I was stucked again....Any suggestion?

Capture4.PNG

Tags (2)
1 Solution

Accepted Solutions
luismadriz
Valued Contributor

Re: Dimension problem

Hi R,

That will limit the value in one table to only the questions you want. Try and you'll see

Cheers,

L

7 Replies
luismadriz
Valued Contributor

Re: Dimension problem

Hi,

For each table you could edit all your measures to something like this:

Count({<[Question no]={"Cus.Q1","Cus.Q2"}>} Respondents)

I hope this helps,

Regards,

L

theglenndavid
New Contributor III

Re: Dimension problem

Create a Master Dimension called Engagement_questions with the following:

If(Match([Custom workshop.Questino no],'Cus.Q1','Cus.Q2','Cus.Q3','Cus.Q4','Cus.Q5') > 1, [Custom workshop.Questino no],Null())

Use this dimension in the left table.

Create another Master Dimension called Learning_questions with the following:

If(Match([Custom workshop.Questino no],'Cus.Q6','Cus.Q7','Cus.Q8','Cus.Q9','Cus.Q10') > 1, [Custom workshop.Questino no],Null())

Use this dimension in the right table.

Note this is off the top of my head and not actually tested.

xiyuzw1113
New Contributor III

Re: Dimension problem

Hi Glenn,

Thanks for your reply. It works while unfortunately not works really well. The table is showed as this. I am not really sure where is Q1 gone and I don't want to display the row with '-'.

Capture 3.PNG

xiyuzw1113
New Contributor III

Re: Dimension problem

Hi Luis, thanks for your reply. Probably it not works for me well, I would like to display the dimension in table one from Question 1 to Question 5. So the point should be figure out how to limit the value displayed in one table. 

luismadriz
Valued Contributor

Re: Dimension problem

Hi R,

That will limit the value in one table to only the questions you want. Try and you'll see

Cheers,

L

luismadriz
Valued Contributor

Re: Dimension problem

Of course you need to continue writing up to Q5, what I wrote was just an example on how to limit to Q1 and Q2

{<[Question no]={"Cus.Q1","Cus.Q2","Cus.Q3","Cus.Q4","Cus.Q5"}>}

xiyuzw1113
New Contributor III

Re: Dimension problem

Hi L, wow thanks so much. It works quite good!

Community Browser