topic Re: Dimension in QlikView

Dimension

Tue, 04 Dec 2012 10:12:47 GMT

Hi All,

I have dimension like Mod_1, mod_2, mod_3 and new_1, new_2, new_3.

Now i want to use 'case statement' so that my result wil b mod_1, mod_2, mod_3 = 'Mod' and same as with 'New'.

please suggest how to use case statemnt in dimesion. I need this on urgent basis.

Thanks

Re: Dimension

sujeetsingh — Tue, 04 Dec 2012 10:17:23 GMT

Akrati,

Clik on calculated dimention tab and write the desired Case Statement for your requirement.

Re: Dimension

sujeetsingh — Tue, 04 Dec 2012 10:18:30 GMT

And if you eloborate your Case functionality than i can help you ..

Re: Dimension

Tue, 04 Dec 2012 10:22:18 GMT

Hi,

In the X-axis, i want MOD and NEW instead of mod_1, mod_2

i want mod_1 and mod_2 comes under MOD by using the case statement.

How its possible?

Re: Dimension

sujeetsingh — Tue, 04 Dec 2012 10:25:17 GMT

Sorry i didnt get u ...Why dont u just give a sample

Re: Dimension

Gysbert_Wassenaar — Tue, 04 Dec 2012 10:33:56 GMT

try this as a calculated dimension:

if(wildmatch(MyDimension,'mod'),'Mod',if(wildmatch(MyDimension,'new'),'New'))

But perhaps you should fix this in the load script by adding a mapping table and using applymap to create a new field ModNew. The use the new field instead of the original dimension.

MapDim:

mapping load * inline [

Key,Value

mod_1, Mod

mod_2, Mod

mod_3, Mod

new_1, New

new_2, New

... etc

];

load *, applymap('MapDim', FieldWithModAndNew) as ModNew

from ... etc

Re: Dimension

Tue, 04 Dec 2012 10:49:00 GMT

thanks for the reply.

I will try this and get back to u.

Re: Dimension

Tue, 11 Dec 2012 06:16:30 GMT

I just want to know, how to rename the expression??

In my tooltip the whole expression is visible.. i want to rename this

how to do?

Re: Dimension

sujeetsingh — Tue, 11 Dec 2012 07:37:00 GMT

Just go to label on expression tab and do it

Re: Dimension

Wed, 12 Dec 2012 07:11:53 GMT

Thanks...

Done with that!!!