topic Dummy Values in QlikView

Dummy Values

Wed, 20 Aug 2014 11:47:50 GMT

Hi all,

I would like to add two dummy values for a single field.

Eg:

Load 0 as Dummy

Yellow and Blue as Colour

from Table name;

I would like to add Yellow and Blue under the field Colour.

Can anyone please help

Thanks & Regards,

Vinitha.

Re: Dummy Values

Wed, 20 Aug 2014 11:53:43 GMT

Vinitha,

You can't add. Not very clear how you will be use in your app, however still if you want to add you can try with the workaround concatenate Yellow and Blue as Yellow_Blue.

Load 0 as Dummy,

Yellow_Blue as Colour

from Table name;

-Ram

Re: Dummy Values

vardhancse — Wed, 20 Aug 2014 11:57:04 GMT

fields what ever you mentioned are there in the table.

If so ,

We can concatenate the fields data.

If not,

We can by using inline statements /

calculated dimension in the chart

Re: Dummy Values

ashfaq_haseeb — Wed, 20 Aug 2014 12:20:01 GMT

Hi,

May be like this.

Table1:

Load * Inline [

Color,Dummy

Red,0

Green,0

];

Concatenate

Load * Inline [

Color,Dummy

Yellow,0

];

Concatenate

Load * Inline [

Color,Dummy

blue,0

];

Regards

ASHFAQ