topic Compare multiple expressions in QlikView

Compare multiple expressions

Thu, 29 Oct 2015 15:25:42 GMT

Hi I have multiple independent expressions that I need to compare and sort all of them (from top to bottom).

For up to 3 expressions, I can easily solve the problem using rangemax.

But for these many, I don't know what to do.

In the attached file, I listed 19 expressions for example.
Think this application as a survey result and there are 19 questions (Q1 to Q19).

By picking the names first, I want to see the top % of each question (the expressions).

Then I want to compare/sort the %.

For example, I picked the names from Alice to Ursula.

The highest % of these 19 questions is 57% - Q6 and Q7.

So I know in Q6 and Q7, these 21 people have the highest commonality.

The goal is to sort all these expressions. Please help, thanks!

Re: Compare multiple expressions

swuehl — Thu, 29 Oct 2015 17:33:08 GMT

Not sure where you want your expressions to be sorted, they are located in different charts.

But maybe like attached?

Re: Compare multiple expressions

Thu, 29 Oct 2015 18:46:33 GMT

Thanks swuehl, using crosstable is a great idea, and the chart you built is exactly what I am looking for. But my original data model is so much more complicated and can't be joined together because of different levels of granularity. I am attaching my original data model and let's see if there's any way besides crosstable?

Re: Compare multiple expressions

swuehl — Thu, 29 Oct 2015 22:15:36 GMT

Sorry, I can't give an advice just looking at the table view screen shots.

Remodelling would also need full knowledge of all requirements.

I must admit I haven't even fully understood what you want to do with the sorted expressions, since the highest commonality as you calculate it also depends on cardinality of the question dimensions (lower cardinality -> higher commonality though answers are equally distributed).

Re: Compare multiple expressions

Mon, 02 Nov 2015 14:03:08 GMT

Thanks swuehl, I created another table with the items I want to compare and was able to sort with crosstable. Your question also gave me something to think about. All these comments are helpful. Thank you very much!