topic Dimensions Swapped in QlikView

Dimensions Swapped

Anonymous — Fri, 07 Jun 2013 21:53:24 GMT

For example:

Pub ID Pub Name Aggr

1 Sports 3

2 Sports 2

3 Retail 5

...

I need to create a bar chart with:

Dimension = PubID

Expression = Count(Aggr)

But, finally I want to display on the chart Dimension as Pub Name and it shold show Sports two times (because of different Pub IDs).

Would appreicate any ideas.

swuehl — Fri, 07 Jun 2013 22:21:59 GMT

Try using

dual( [Pub Name], [Pub ID] )

as dimension, either by creating a new field in your load script or as calculated dimension.

Anonymous — Fri, 07 Jun 2013 22:42:18 GMT

It works for the example above but when I try it on actual data model, it does not seem to work.

I wonder this is because these values come from two different tables ?

swuehl — Fri, 07 Jun 2013 22:47:45 GMT

So how does your data model looks like? Could you post some more details or a small sample app?

Anonymous — Fri, 07 Jun 2013 22:54:26 GMT

Attached (with the very first message from me) a sample.

swuehl — Fri, 07 Jun 2013 23:09:09 GMT

Can't really see a problem, I still get as result

Anonymous — Fri, 07 Jun 2013 23:30:47 GMT

I understand, it works perfectly fine on the sample but somehow not on actual data i have.