topic Re: flag? in QlikView

flag?

Anonymous — Mon, 29 Dec 2014 11:06:46 GMT

i have like

t1:

load

sales

amount

from sales.xlsx

now i am talikng resident for this

load

sales

'last_sales' as endsales

amount

resident t1;

here created a flag called 'endsales' i understood

my question what is the data in inside the field of 'endsales' i guess data would be 'last_sales'

if not pls correct me ?

if yes what is the use of this flag here?

Re: flag?

Mon, 29 Dec 2014 11:22:31 GMT

Hi,

Here like this u vl get the data

Sales Endsales

100 last_sales

200 last_sales

130 last_sales

290 last_sales
300 last_sales

Re: flag?

its_anandrjs — Mon, 29 Dec 2014 11:32:13 GMT

Hi,

You get last_sales string in all rows in the t1 table

sales, endsales , amount

7841, last_sales, 45812

...

Regards

Anand

Re: flag?

Anonymous — Mon, 29 Dec 2014 13:48:46 GMT

Your table will be loaded like this :

Sales Endsales Amount

100 last_sales 10

200 last_sales 50

130 last_sales 30

290 last_sales 10

300 last_sales 40

This flag is not useful until you are loading other tables as well like

If you load other table where you need to have flag 'Start_Sales' to identify the start sales amount.

Now in your expression you can use these flags to identify which amount belongs to END_SALES and which belongs to START_SALES .

Hope this help.