topic Re: Monetary sales range in QlikView

Monetary sales range

cafcptg2011 — Fri, 09 Sep 2011 11:42:13 GMT

Hello,

I need to make a simple table with monetary sales range, but i'm stuck. I have a qvw with my problem to understand more quickly my pb.

Can anyone please help me?

Thanks in advance,

Cafc

Re: Monetary sales range

Sokkorn — Fri, 09 Sep 2011 12:19:00 GMT

Hi Cafc,

Please check in my attached file.

Let me know if this one help you.

Regards,

Sokkorn

Monetary sales range

cafcptg2011 — Fri, 09 Sep 2011 13:12:22 GMT

Hi Sokkorn,

yeah that's correct!!! thank you very much!

Cafc

Re: Monetary sales range

cafcptg2011 — Fri, 09 Sep 2011 15:53:14 GMT

suppose now that i need to aggregate the sales for each customer in that monetary sales range. I have attached a qvw file to be more easy to understand what i mean.

thanks in advance,

cafc

Re: Monetary sales range

Sokkorn — Sat, 10 Sep 2011 01:17:09 GMT

Hi Cafc,

Check my attached file to solve your problem. This one is not a good solution for you yet. If you have agood one besides my attached file, do let me know.

Regards,

Sokkorn

Re: Monetary sales range

cafcptg2011 — Mon, 12 Sep 2011 16:24:37 GMT

I adopted another solution... instead using a loading script (because, your solution doesn't work in my real data, i dont' know why.... 🙂 ) so, I created a calculated dimension to acomplished that, like:

if(aggr(Sum(sales),id_customer)<=500, '0 - 500',

(if(aggr(Sum(sales),id_customer)>500 and aggr(Sum(sales),id_customer) < 750, '500 - 750', ))

But with this, I can't sorted these ranges ... it gives me:

1000-1500

0-500

500-750, and so one....

i think I have to live with that... but if we have any suggestion.... 🙂

thank you for help.

regards

cafc

Re: Monetary sales range

Sokkorn — Tue, 13 Sep 2011 00:33:58 GMT

Hi Cafc,

It a good solution. For sort order you can check in my attached file.

Regards,

Sokkorn

Re: Monetary sales range

cafcptg2011 — Tue, 13 Sep 2011 08:21:53 GMT

Hi Sokkorn,

it's perfect! thank you very much...

regards,

cafc