topic hi.. in QlikView

hi..

Thu, 29 Mar 2012 09:46:26 GMT

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

rohit214 — Thu, 29 Mar 2012 10:47:40 GMT

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

Thu, 29 Mar 2012 10:52:21 GMT

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

Thu, 29 Mar 2012 11:33:26 GMT

Hi,

You can put

sum(if(Flag=1,Marks)

or set analysis expression

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

in chart .

Thu, 29 Mar 2012 16:29:10 GMT

thanks..