Fórmula Sum(if

[#1]

Hello.

I'm starting in use of qlikview, and when doing an expression in the pivot table with info. Specific product sales stumbled into an error using Sum (If

I have to do this expression selecting about 500 products ... And when executing the command does not appear anything ...

So I would like your help to correct my expression, or changed it

Regards.

Thank you.

[vishsaggi]

Can you share a sample to look into, you have toooo many IF's can use ApplyMap or something else to cut down these if's , can you elaborate a little on your expected output with a sample. ?

[#3]

Thank you again.

I am using the IF to select 500 products, and display within the "Fernanda I" table, nothing appears. Attached image. The table of product codes is a COD_PROD

[vishsaggi]

Share your sample data with qvw file, it is kind of tough to analyse with the images you send.

[vishsaggi]

I dont need the qvo file, i cant work on the data you sent. Please elaborate your requirement and send us a qvw file with some data to work on.

[Anil_Babu_Samineni]

May be you used {1} for nothing happen while filter. Would you share expressions for data points

[#7]

I'm sorry, but i don't know how to save the file in this format

[#8]

I found at first that the error was due to the excess of arguments, but when I parted the formula and put a sum with a reduced number of conditions, it continues giving error.

I'll try your suggestion.

Thanks

[vishsaggi]

Which file you are working on Qlikview or Qliksense ?