STORE Statement in QlikSense

[George_Metrakos]

Is QlikSense Desktop and Enterprise the only versions where a STORE statement (to QVD) is allowed?

I have a data where I need to accumulate and tag various elements during the load process, so that I can load the same data with these new characteristics added.

For example, if I have sales orders from customers over a year, I want to tag customers who have ordered more than once as a "Repeat" customer.  I want to then re-load all the data again, but include this "tag".

I would like to perform this in QlikSense Cloud for Business- is this possible?

Thanks,

George

[gbommisetti · Accepted solution]

First load the sales table:

sales:

load * from ...

then use resident load and group by to get the count of sales per customer

LOAD customer_id,

     If(count(sales_id) >1,'Repeat','-') as Tag

Resident sales

Group by customer_id;

you can now join both the tables.

[George_Metrakos]

Thank you!