topic Re: Problem on dimension restriction to show the lowest value in QlikView

Problem on dimension restriction to show the lowest value

bimala0507 — Tue, 15 Apr 2014 05:23:29 GMT

Hi:

I am facing a typical issue in dimension restriction. I would like to see Top 10 materials which has largest price difference between 2013 and 2014 and similarly would like to show Top 10 Materials with lowest price difference and I would like to show irrespective of the selection. While it shows me Top 10 of largest price diff., but not showing the materials with lowest price difference unless I select the Year 2013. Attached my qvw files. Is there something I need to do to show the lowest value.

Appreciate a quick reply, as I am stuck up. Any feedback regarding this issue would be highly appreciated.

Re: Problem on dimension restriction to show the lowest value

sujeetsingh — Tue, 15 Apr 2014 05:33:55 GMT

It will be better if you go for buttons which make select in field with all this limitings

Re: Problem on dimension restriction to show the lowest value

tresB — Tue, 15 Apr 2014 05:34:31 GMT

Try expression:

=Sum({1} $(v_netprice_2014) - $(v_netprice_2013))

Re: Problem on dimension restriction to show the lowest value

SunilChauhan — Tue, 15 Apr 2014 05:35:12 GMT

use

-(Expression used in chart) in sort Expression

hope this helps

Re: Problem on dimension restriction to show the lowest value

bimala0507 — Tue, 15 Apr 2014 05:50:03 GMT

Hi:

Thanks much. Surprisingly this works, but not able to understand, why MIN does not work.

Re: Problem on dimension restriction to show the lowest value

Tue, 15 Apr 2014 05:58:09 GMT

Are MATNR and Material No. are 2 different fields??

Because you are using MATNR in 1st chart and Material No. in second chart.

By using MATNR in second chart, its working fine.

Try this way.

Re: Problem on dimension restriction to show the lowest value

tresB — Tue, 15 Apr 2014 06:14:12 GMT

Min() doesn't work because of null/zero values. Go to presentation tab and uncheck 'Suppress Zero Values' and 'Supress Null Values'; you would see the output.

Re: Problem on dimension restriction to show the lowest value

bimala0507 — Tue, 15 Apr 2014 06:22:27 GMT

Thank you so much. Appreciate the explanation.

Kind Regards,

Bimala