Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi members of the Qlik Community!
I have just joined a tech startup as a business analyst, and while I have no problems performing routine tasks right within Qliksense, I am starting to run into more complex problems, some of which I have little to no clue to go about solving it
For instance, I am trying to generate a list of customers who fulfills the below conditions:
Orders at least once in 2016/10 and at least once in 2016/17 AND
Delivery fails to reach them due to 'Error' at least once in both times
...and I have the following key fields available:
[1] customer_id (e.g. alphanumeric string)
[2] package_id (e.g. alphanumeric string)
[3] delivery_failed_reason (e.g. 'Error', 'Rejected', 'Cancelled', 'N/A')
[4] delivered_date (e.g. 2016/10, 2016/11, 2016/12, ...)
[5] country (e.g. RU, DE, AU, SK)
In my feeble attempt I have tried the following in a straight table:
DIM:
if(delivered_date = '2016/10' or delivered_date = '2016/11', customer_id)
MEASURE:
count (distinct if(wildmatch('*Error*, delivery_failed_reason), package_id))
I then apply a count function to the measure column, which would ideally provide the count of customers fitting conditions & . However numbers dont look right so far..
Any advice would be much appreciated!
Thank you!