Hi, I have just started using qliksense and I don't know to proceed with this.
There are data from different countries.
Eg. India:
columns: customerID, Date, Amountspent
customerID for India has a unique prefix 'IN' so it would look like this, IN421445
Malaysia:
columns:columns: customerID, Date, Amountspent
customerID for Malaysia has a unique prefix 'MY' so it would look like this, MY879745
I am required to have data visualization for both within countries and across countries.
so I need to have a script like this:
Script section A(to load all files AUTOMATICALLY)
if Vcountry='MY' (Malaysia)
run script B which changes some of the fields and renames everything to MY.field
if Vcountry='India'
run script B which changes some of the fields and renames everything to India.field
I also don't want to manually copy-paste script B for all the different countries, is there any way to make it repeat automatically?
However I have no idea how to go about doing this, any help would be much appreciated! thank you
