Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Thank you!