For function problem

[#1]

Hi,

I want to show for all the partType of a Country the total of sales per customer.

example:

Country  PartType  customer  Sales

France   E1              BMW     50

France   E2             PSA        10

France   E3             BMW        5

In my Qlikview Document when i select BMW, i got two lines with 50 and 5

What i want is to see 3 lines : 50 , 5,  0 (for E2 partType)

and this for all customers and countries.

For that i tried to use the FOR function but it doesn't seem to work correctly.

Please find attached my example.

Thanks for your help.

[Gysbert_Wassenaar]

Add an expression sum({1}1) to your straight table and then hide that column on the Presentation tab.