hi..

[#1]

what is flag in qlikview and how to use it ??

[rohit214]

Hi Sumit

Flag is nothing but the  like a identifire , it is use to identify which value comes from which table or data source

for example

suppose you have 2 execl files where all the fields having same name and you want to

concatenate both tables but you want to identify which data comes from which execl file.

so your script look like

LOAD

'TABLE1' as Flag,

field1,

field2,

.

.

.

.

.from

xyz.xls;

concatenate

LOAD

'TABLE2'   as Flag,

field1,

field2,.

.

.

.

.

from abc.xls;

thanks& regard

rohit

[#3]

thanks can u plz explain how we can use it in chart expression for calculation??

[#4]

Hi,

You can put

sum(if(Flag=1,Marks)

or  set analysis expression

sum({<Flag={1}>Marks}

in chart .

[#5]

thanks..