topic Re: Flag in QlikView

Flag

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi ALl,

Can anyone explain what doe flag means " what do we mean by create a flag in qlikview ?

Thanks in advance

Re: Flag

Anil_Babu_Samineni — Wed, 22 Mar 2017 03:10:25 GMT

Assume, You have null values and few data sets with you

Load * Inline [

Name, Value

-, 10

A, 20

B, 30

];

From here if we create flag over here

Load *,

If(Name = '-', 1, 0) as Flag

Resident Directory;

Then use in set analysis with null values

Sum({<Flag = {'1'}>}Value) // It returns only Null values of Value.

Sum({<Flag = {'0'}>}Value) // It returns without Null values of Value.

Re: Flag

Wed, 22 Mar 2017 03:13:25 GMT

Hi John,

Flag is a new derived field like below

load

product,

sales,

'jan' as flag

from .........xl;

flag is a column here u can identify the month in the flag

Re: Flag

beck_bakytbek — Wed, 22 Mar 2017 08:18:12 GMT

Hi John,

to issue: flags, if you are using set expressions, they tend to become overly complex when they are too many comparison sets and conditions put in place,

In order to reduce the complexity, one can make use of the flags created in the script in set analysis expressions.

The flags can be set up to be simple binary value, 0 and 1.

Use of flags optimizes the performance of fronted calculations.

The above examples are perfect examples to understand this issue.

i hope that helps

beck