Calculate Expression Without Dimension

doganogulturk — Thu, 20 Jun 2019 16:12:25 GMT

hi. in my work, i'll calculate the percentage of active, passive and lost customers. i'll explain these words:

if the customer's last transaction is in the last 3 months, this customer is active. if the customer has not a transaction in the last 3 months but has in previous 3 months, he is passive. if not both, i say he is lost.

now, i want to calculate 3 numbers: how many customers are active, passive and lost.

in a straight table, i used customer id as dimension, max(date) as expression1. as expression2, if expression1 is bigger than AddMonths(date(now()),-3), i mark it 1, else 0. like that, expression3 is, if expression1 is bigger than AddMonths(date(now()),-6), i mark it 1, else 0. and finally expression4, if expression1 is bigger than AddMonths(date(now()),-12) i mark it 1 else 0.

finally sum of the expression2, 3 and 4 are the goal numbers.

but i wonder, can i calculate the count of customers?

Re: Calculate Expression Without Dimension

Brett_Bleess — Mon, 22 Jul 2019 15:36:26 GMT

If you can attache a sample app, that may help someone provide some further guidance on this one.

Regards,
Brett

topic Calculate Expression Without Dimension in QlikView

Calculate Expression Without Dimension

Re: Calculate Expression Without Dimension