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:
[A] Orders at least once in 2016/10 and at least once in 2016/17 AND
[B] Delivery fails to reach them due to 'Error' at least once in both times
...and I have the following key fields available:
 customer_id (e.g. alphanumeric string)
 package_id (e.g. alphanumeric string)
 delivery_failed_reason (e.g. 'Error', 'Rejected', 'Cancelled', 'N/A')
 delivered_date (e.g. 2016/10, 2016/11, 2016/12, ...)
 country (e.g. RU, DE, AU, SK)
In my feeble attempt I have tried the following in a straight table:
if(delivered_date = '2016/10' or delivered_date = '2016/11', customer_id)
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 [A] & [B]. However numbers dont look right so far..
Any advice would be much appreciated!