topic Re: STORE Statement in QlikSense in App Development

STORE Statement in QlikSense

George_Metrakos — Sat, 16 Nov 2024 06:18:16 GMT

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

Re: STORE Statement in QlikSense

gbommisetti — Thu, 21 Mar 2019 15:34:22 GMT

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.

Re: STORE Statement in QlikSense

George_Metrakos — Thu, 13 Jun 2019 12:01:49 GMT

Thank you!