Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dummy Values

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.

3 Replies
Not applicable
Author

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

vardhancse
Specialist III
Specialist III

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

ashfaq_haseeb
Champion III
Champion III

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