Dimension problem

[Anonymous]

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

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?

[luismadriz]

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]

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.

[Anonymous]

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 '-'.

[Anonymous]

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 · Accepted solution]

Hi R,

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

Cheers,

L

[luismadriz]

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"}>}

[Anonymous]

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