topic Re: Help: Dimension Values in QlikView

Help: Dimension Values

Sat, 07 Apr 2012 10:50:06 GMT

Hi,

I need help with the dimension values in straight table.

I have a straight table with one dimension which takes certain values (A,B,C,D). I would like to add dummy values to this dimension (AA, BB, CC etc).I was wondering is there is a way in which i can do this without loading new data.

Thanks,

Harsha

Help: Dimension Values

Sat, 07 Apr 2012 15:44:27 GMT

Hi Harsha

In what sense do you mean add dummy values? If you mean converting the existing values to a different representation, you can use a calculated dimension to achieve this.

In your case, you would set the calculated dimension as:

=[Your DimensionField] & [Your DimensionField]

This will concatenate the dimension to itself and convert 'A' -> 'AA', 'B' -> 'BB'

Let me know if this is not what you need

Erica

Re: Help: Dimension Values

Anonymous — Sat, 07 Apr 2012 19:22:03 GMT

Hi, if you wanna have another value which doesnt have any direct relation to your first dimension you can use the Rand() function, or an nested if clause. /Marcus

Help: Dimension Values

Sun, 08 Apr 2012 04:46:15 GMT

Thank you for your replies Erica and Marcus.

Find attached the excel which shows what i am looking for. I want to add values to the existing dimension. Hope i have explained better

Any ideas of how i can achieve this without loading new data.

Tkx

Harsha

Re: Help: Dimension Values

Sun, 08 Apr 2012 04:47:51 GMT

With attachment

Re: Help: Dimension Values

Anonymous — Sun, 08 Apr 2012 07:13:39 GMT

Hi Harsha, im not sure i understand, cant you just add new calculated dimensions in the straight table and rename them? what kind of values do you want to have in the new dimensions? /Marcus

Re: Help: Dimension Values

Sun, 08 Apr 2012 08:41:01 GMT

Hi Marcus,

I am not trying to add a new dimension. I have only one dimension and i want to show only one dimension finally as well.

My dimension takes certain values. I want to assign some more values to the same dimension (in addition to the values it currently takes), which are not a part of the data. Even though there will be no data showing for these dummy dimension values I want to show them as a part of the table. Hope i am clear.

Any ideas of how i can do this?

Tkx

Re: Help: Dimension Values

Anonymous — Sun, 08 Apr 2012 09:54:23 GMT

Something like this? (see attached file)

Help: Dimension Values

Jason_Michaelides — Sun, 08 Apr 2012 10:37:54 GMT

Maybe have a look at ValueList(). You could possible create a variable using Concat() to get the existing values and add the others into the ValueList(). Can't test it right now but maybe it'll work...

Hope this helps,

Jason