Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HOW TO CREATE FLAGS?
AND WHAT IS THE USE OF FLAGS?
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
you can create FLAG by using if condition in script.
which is useful at the time of creating set analysis logic.
- Regards,
Vishal Waghole
any example with qvw
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
Hi Manoj,
PFA with example.
Hope it will solve your problem.
- Regards,
Vishal Waghole
Hi manoj, if you satisfied then please close this discussion.
-- Regards,
Vishal Waghole
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
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.
hi,
how to create flag for matching two values
Thank you