Sorting only expression

[pauldamen]

Dear all,

I have a horizontal bar chart, which has only expression (different questions in a questionairre loaded from an excel file). It is counting the number of times a respondend answered that question (1 and 0 in excel). So excel looks like this: 5 colums for every question 1 and then every line is an responded. It says a 1 when the question is answered and  a 0 if not. So far so good.

So the horizontal bar chart counts how many times every question is answered. Now the part that I can't figure out: how to sort the expression, so I only want to see the top 5 of answered question. But since I only got expressions I can't sort it.

I attached the file hope you guys can help!

Regards,

Paul

[jagan · Accepted solution]

Hi,

Check the attachment for solution.

Hope it helps you.

Regards,

Jagan.

[pauldamen]

It works great! Can you explain what you did?Because now there are 5 questions but it will be a list of 25

[jagan]

Hi,

I just created a temporary dimension using ValueList(). 

If you have 25 expressions then you need to use 25 if conditions, likewise i did for 5.

Regards,

Jagan.