Qlik Community

Qlik Sense Advanced Authoring

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

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
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

Labels (2)
1 Solution

Accepted Solutions
Highlighted
Contributor II
Contributor II

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.

 

View solution in original post

2 Replies
Highlighted
Contributor II
Contributor II

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.

 

View solution in original post

Highlighted
Contributor
Contributor

Thank you!