Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
commonqlik
Creator III
Creator III

flag?

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?

1 Solution

Accepted Solutions
Not applicable

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

View solution in original post

3 Replies
Not applicable

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

its_anandrjs

Hi,

You get last_sales string in all rows in the t1 table

sales, endsales , amount

7841,  last_sales, 45812

...

...

Regards

Anand

balkumarchandel
Specialist II
Specialist II

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.