topic Re: Problem Sales and Stock in QlikView

Problem Sales and Stock

Wed, 02 Sep 2015 11:45:34 GMT

Good Morning

I have the attached example, I need to show the selected articles with stock independent they have had sales.

I use the expresion sum({ <mes articulo >} stock)

It shows all the months (with cero value in sales when no selected that month) perfect!!

But it shows all the months (with cero on sales) I only want to display the selected months and all the articles with stock

I need the sales of the selected months and the stock of all the articles.

Thanks

Re: Problem Sales and Stock

avinashelite — Wed, 02 Sep 2015 11:49:15 GMT

check this:

expression should be

sum({ <mes, articulo >} stock)

Re: Problem Sales and Stock

Wed, 02 Sep 2015 11:58:21 GMT

Thanks for your answer but the problem persist.

If I select only a month in the pivot table (2 for example) it stills show month 1 and 3 (with cero values) but I only want month 2 to appear of it has sales or null if it has no sales but has stock

Thanks

Re: Problem Sales and Stock

avinashelite — Wed, 02 Sep 2015 12:15:25 GMT

check this

Re: Problem Sales and Stock

Marcellino_Groothof — Wed, 02 Sep 2015 13:23:45 GMT

Hi,

Try this:

sum ({$<mes=, articulo=>} stock)

Regards

Re: Problem Sales and Stock

Wed, 02 Sep 2015 13:24:13 GMT

Thanks again

Well, I think I'm not explaining

I need to show in the pivot table only the selected months.

If there is any sales in the select month it mast appear (in ventas)

If there is not sale in the selected month but there is stock for the article the month will be null and stock appears on column reference as stock

In my example if you select mes 2 and alll articulos

it must appear

articulo mes ventas stock

1 2 20 10

2 - 0 20

3 - 0 30

4 - 0 5

And if you select mes 1 and all the articulos it must appear

articulo mes ventas stock

1 1 10 10

2 1 200 20

3 1 10 30

4 - 0 5

Thanks

Re: Problem Sales and Stock

Wed, 02 Sep 2015 13:31:38 GMT

Thanks for your response but i'm answering the same

I need to show in the pivot table only the selected months.

If there is any sales in the select month it mast appear (in ventas)

If there is not sale in the selected month but there is stock for the article the month will be null and stock appears on column reference as stock

In my example if you select mes 2 and alll articulos

it must appear

articulo mes ventas stock

1 2 20 10

2 - 0 20

3 - 0 30

4 - 0 5

And if you select mes 1 and all the articulos it must appear

articulo mes ventas stock

1 1 10 10

2 1 200 20

3 1 10 30

4 - 0 5

Thanks

Re: Problem Sales and Stock

avinashelite — Wed, 02 Sep 2015 14:10:55 GMT

Hi Gonzalo,

I got your requirement , please find the attachment for the solution , its bit tricky

Re: Problem Sales and Stock

Wed, 02 Sep 2015 14:41:16 GMT

I appreciate your effort

But the problem persist

it appears months without sales like

mes mes

1 -

when you select month 2

Thanks

Re: Problem Sales and Stock

avinashelite — Thu, 03 Sep 2015 04:36:45 GMT

hey did you check the attachment ?? which i sent earlier

Re: Problem Sales and Stock

Thu, 03 Sep 2015 06:19:29 GMT

Re: Problem Sales and Stock

Anonymous — Fri, 02 Oct 2015 07:34:15 GMT

Thanks again and excuse me because i was too busy and i didn`t have enough time

I'm going to try it now and i will answer you

Thanks