topic Re: HOW TO CREATE FLAGS? in QlikView

HOW TO CREATE FLAGS?

Wed, 09 Jul 2014 06:26:23 GMT

HOW TO CREATE FLAGS?

AND WHAT IS THE USE OF FLAGS?

Re: HOW TO CREATE FLAGS?

VishalWaghole — Wed, 09 Jul 2014 06:29:56 GMT

you can create FLAG by using if condition in script.

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

- Regards,

Vishal Waghole

Re: HOW TO CREATE FLAGS?

Wed, 09 Jul 2014 06:35:55 GMT

any example with qvw

Re: HOW TO CREATE FLAGS?

Wed, 09 Jul 2014 06:40:55 GMT

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

Re: Re: HOW TO CREATE FLAGS?

VishalWaghole — Wed, 09 Jul 2014 06:47:10 GMT

Hi Manoj,

PFA with example.

Hope it will solve your problem.

- Regards,

Vishal Waghole

Re: HOW TO CREATE FLAGS?

VishalWaghole — Wed, 09 Jul 2014 07:52:56 GMT

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

-- Regards,

Vishal Waghole

Re: HOW TO CREATE FLAGS?

Wed, 09 Jul 2014 07:59:48 GMT

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

Re: HOW TO CREATE FLAGS?

Wed, 09 Jul 2014 09:50:14 GMT

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.

Re: HOW TO CREATE FLAGS?

Chanty4u — Wed, 08 Jul 2015 07:45:17 GMT

hi,

how to create flag for matching two values

Thank you