topic Re: dynamic dimension in QlikView

dynamic dimension

Tue, 11 Dec 2012 09:37:56 GMT

hi,

I am trying to create a dynamic dimension based on the possible values of a field. I know how to get the possible values of my field (concat(myfield, ', ')). if i put this in a if like if(concat(myfield, ', ') = 'KBS'), 'hello', 'Bye') it also works fine. I tested this in a textbox. so far so good. if i try this in a pivot table for a dynamic dimension I always get an error. my dynamic dimension looks like this: if(concat(myfield, ', ') = 'KBS', field1, field2)

may someone help me?

regards,

Re: dynamic dimension

Or — Tue, 11 Dec 2012 09:42:28 GMT

concat() is an aggregation function, if memory serves, which means you can't use it directly in your dimension formula. You'd have to wrap it in an aggr() function.

Re: dynamic dimension

Tue, 11 Dec 2012 09:44:08 GMT

and how would that look?

Re: dynamic dimension

Or — Tue, 11 Dec 2012 09:46:39 GMT

Without knowing what your datamodel looks like,

if(aggr(concat(myfield, ', '),SomeDimension) = 'KBS', field1, field2)

Where SomeDimension is a dimension that will not interfere with your aggregation (if no such dimension exists, you can create something like "Load 1 as SomeDimension" in your script and leave it loose, which should work). There's probably a neater way of doing that, though.