topic Re: Sorting only expression in QlikView

Sorting only expression

pauldamen — Fri, 24 Feb 2012 11:24:31 GMT

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

Re: Sorting only expression

jagan — Fri, 24 Feb 2012 12:18:02 GMT

Hi,

Check the attachment for solution.

Hope it helps you.

Regards,

Jagan.

Re: Sorting only expression

pauldamen — Fri, 24 Feb 2012 14:11:45 GMT

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

Sorting only expression

jagan — Fri, 24 Feb 2012 15:02:23 GMT

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.