topic Re: Fórmula Sum(if in QlikView

Fórmula Sum(if

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Fórmula Sum(if

vishsaggi — Thu, 13 Apr 2017 16:09:31 GMT

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. ?

Re: Fórmula Sum(if

Thu, 13 Apr 2017 17:33:48 GMT

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

Re: Fórmula Sum(if

vishsaggi — Thu, 13 Apr 2017 18:44:14 GMT

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

Re: Fórmula Sum(if

vishsaggi — Thu, 13 Apr 2017 20:40:09 GMT

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.

Re: Fórmula Sum(if

Anil_Babu_Samineni — Fri, 14 Apr 2017 01:49:18 GMT

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

Re: Fórmula Sum(if

Mon, 17 Apr 2017 13:16:27 GMT

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

Re: Fórmula Sum(if

Mon, 17 Apr 2017 13:20:42 GMT

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

Re: Fórmula Sum(if

vishsaggi — Mon, 17 Apr 2017 15:34:24 GMT

Which file you are working on Qlikview or Qliksense ?