Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Highlighted
George_Metrakos
New Contributor

STORE Statement in QlikSense

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

1 Solution

Accepted Solutions
gbommisetti
New Contributor II

Re: STORE Statement in QlikSense

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.

 

2 Replies
gbommisetti
New Contributor II

Re: STORE Statement in QlikSense

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
New Contributor

Re: STORE Statement in QlikSense

Thank you!