topic A better layout solution in QlikView

A better layout solution

Wed, 06 Jan 2010 12:02:12 GMT

Hello !

I have a situation here where I need a "matrix" of several boxes where each one has a different formula. Pretty much like a table except that on each cell I have a totally different formula (Excel mimic).

Take a look at the attached screen shot and you'll see what I mean.

I have dont that using Text Objects but I don't think this is the best way of doing it.

Would someone else have a better layout solution ?

Thanks !

A better layout solution

justinasp — Wed, 06 Jan 2010 12:17:16 GMT

Hi, Adriano

why don't you use the Chart Object - Straight table with horizontal layout.?

I guess it should work.

Justinas

A better layout solution

Wed, 06 Jan 2010 12:21:20 GMT

One way is to use a pivot table without any dimensions and add your expressions one by one.

Hope it helps
/Fredrik

A better layout solution

Wed, 13 Jan 2010 14:24:07 GMT

Thanks Justinas !

Great ! It works.

However the value column appears two times.

See the attached example !

Guess what it could be ?

Thanks !

A better layout solution

Wed, 13 Jan 2010 19:04:11 GMT

If you look on the Expressions tab and then on the right side, you see Total Mode. This should be 'No Totals' for both expressions.

A better layout solution

Thu, 14 Jan 2010 16:55:50 GMT

Great !

Now the problem is that I have a "citation" or "label" and TWO expressions on each row....

On the attached file, I need for "TOTAL 1" two values or expressions on the same row...

How could I do that ?

A better layout solution

Thu, 14 Jan 2010 20:14:04 GMT

A dirty solution for this particular question ...

You can set all expressions to Horizontal on the presentations tab. I also added a calculated dimension called ='Total 1'

Play with it a bit in your original qvw.

A better layout solution

justinasp — Fri, 15 Jan 2010 08:35:01 GMT

Hi, Adriano,

I'm not sure if my last post disappeared or what, but I was writing that the only solution that came into my mind was to use fake dimention with IF(..) clause. I attached example, where that dimention has "Hide Column" option on "Presentation" sheet in Chart Properties.

Take care,

Justinas

A better layout solution

Fri, 15 Jan 2010 11:23:04 GMT

Ok Justinas.

But wonder if I have 300 expressions !

Yes I could use the PICK function for that but guess it would be cumbersome...

So , here I post another question :

What if I had a DATABASE of TITLES or LABELS (left column) AND their corresponding expressions as a field ?

So, for instance, a database like this :

LABEL ;EXPRESSION

TOTAL 1 ;SUM(VALUE_FIELD)

TOTAL 2 ;SUM(IF(GENDER = 'F',BREAST_SIZE,0)

The dimension would be the LABEL of course but the EXPRESSIONS should be EVALUATED upon exhibition.

Feasible ?

Thanks !