HOW TO CREATE FLAGS?

[#1]

HOW TO CREATE FLAGS?

AND WHAT IS THE USE OF FLAGS?

[VishalWaghole]

you can create FLAG by using if condition in script.

which is useful at the time of creating set analysis logic.

- Regards,

Vishal Waghole

[#3]

any example with qvw

[#4 · Accepted solution]

hi

flag generally make according to the data.

example-

suppose, you have two table like

Table1:

load *  ,'1' as FLAG

inline [

id, value

1, 200

2, 300

3, 42

];

join

Table2:

load * ,  '0' as FLAG

inline [

id, value

1, 20

2, 30

3, 42

];

then here FLAG  show that 0 use for data of Table2 and 1 use for data of Table1

[VishalWaghole]

Hi Manoj,

PFA with example.

Hope it will solve your problem.

- Regards,

Vishal Waghole

[VishalWaghole]

Hi manoj, if you satisfied then please close this discussion.

-- Regards,

Vishal Waghole

[#7]

Hi Manojqlik,

You can create flags in your script. By doing the following for instance.

if(Activation_Flg = 'Y', 1, 0)          as Activation_Flag

By using 1's and 0's you can speed up your model quite significantly.

In your chart you will then do sum(Orders) * Activation_Flag instead of doing the following sum(if(Activation_Flag = 'Y', Orders) which is much slower then using the first example.

Kind Regards,
Marius

[#8]

Hiii Manoj,

In QV flags are used as a binary status indicator, it is used to signal or mark certain states. Further, the process to create flags is already described and discussed above.

You may also check this video tutorial for further information on Qlikview :- https://www.youtube.com/watch?v=8olMt2AOUJ8.

[Chanty4u]

hi,

how to create flag for matching two values

Thank you