topic Re: Bottom 3 but with a dimension condition in QlikView

Bottom 3 but with a dimension condition

cafcptg2011 — Fri, 09 May 2014 11:36:41 GMT

Hi,

I need to do a bottom 3 ranking but with one condition on my dimension, ie, i need to konw the bottom 3 region but with sales >0. I have attached qvw file to better understand my problem.

Could someone help me please on this.

Thanks in advance,

CAFC

Re: Bottom 3 but with a dimension condition

anbu1984 — Fri, 09 May 2014 11:47:35 GMT

Try this

Re: Bottom 3 but with a dimension condition

Gysbert_Wassenaar — Fri, 09 May 2014 12:13:40 GMT

See attached qvw.

Re: Bottom 3 but with a dimension condition

mahesh_agrawal — Fri, 09 May 2014 12:47:17 GMT

Hi,

Please find the attached QVW file.

I have shown 3 tables.

1. Shows normal ranking of all region

2.Bottom 3 regions including regions having zero sales
3..Bottom 3 regions excluding regions having zero sales(Final Output)

I hope it answers your problem.

Re: Bottom 3 but with a dimension condition

cafcptg2011 — Fri, 09 May 2014 14:32:14 GMT

Hi,

Thanks for your reply, it your solution works great! thanks for your help!

could you please explain me if i have one more variable, let's say orders, how can I do the same but if sales > 0 and orders >0 to filter the bottom 3.

thanks in advance,

your expression: sum({<Region={"=rank(-sum({<Sales={'>0'}>}Sales),4,1)<=$(vLimit)"}>}Sales)

Re: Bottom 3 but with a dimension condition

cafcptg2011 — Fri, 09 May 2014 15:51:51 GMT

thanks for your answer!