Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I'm new to QlikView and have a hard time excluding certain values from calculating the percentage of a dimension.
in expressions I have the following formula:
Count ({<Order_Status = {'Pre-Order'}>} Order_Status) / Count (Order_Number)
and I would like to exclude from the count the records that in the field [Reason] contain the value 'reinsert'.
I tried like this:
if (not match (Reason, 'REINSERT'), Count ({<Order_Status = {'Pre-Order'}>} Order_Status) / if (not match (Reason, 'REINSERT'), Count (Order_Number)))
But it does not work. can you suggest me a solution?
Hi,
Try this one:
Count ({<Order_Status = {'Pre-Order'}, Reason-={'REINSERT'}>} Order_Status) / Count ({<Reason-={'REINSERT'}>} Order_Number)
Hi,
Try this one:
Count ({<Order_Status = {'Pre-Order'}, Reason-={'REINSERT'}>} Order_Status) / Count ({<Reason-={'REINSERT'}>} Order_Number)
It works, thanks a lot 🙂