For function problem

Mon, 16 Dec 2013 15:38:00 GMT

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.

Re: For function problem

Gysbert_Wassenaar — Mon, 16 Dec 2013 15:53:29 GMT

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