Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem Sales and Stock

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

11 Replies

check this:

expression should be

sum({ <mes, articulo >}  stock)

Not applicable

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

check this

Contributor III
Contributor III

Hi,

Try this:

 

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

Regards

Not applicable

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

Not applicable

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

Hi Gonzalo,

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

Not applicable

I appreciate your effort

But the problem persist

it appears months without sales like

mes   mes

1         -

when you select month 2

Thanks

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