Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
milindnikumbh
New Contributor III

Product type wise sum is not showing for multiple currency

Dear Expert ,

I am not able to get the product type wise sum of quantity for multiple currencies.

Qty * Rate total is coming for some product types who have single currency.

Please suggest your solution. Files are attached for your reference.

Thanks & Regards,

Milind.

1 Solution

Accepted Solutions

Re: Product type wise sum is not showing for multiple currency

I am not sure I understand... is this not what you want?

Capture.PNG

What is wrong?

View solution in original post

10 Replies

Re: Product type wise sum is not showing for multiple currency

Try this

=Num(Sum(QTY * RATE * Pick(Match(Upper(CUR), 'INR', 'GBP', 'EUR', 'USD'), 0.02, 1.60, 1.32, 1))/1000000, '#####.000')

Highlighted
milindnikumbh
New Contributor III

Re: Product type wise sum is not showing for multiple currency

Thanks Sunny. But no luck. Its same.

Re: Product type wise sum is not showing for multiple currency

I am not sure I understand... is this not what you want?

Capture.PNG

What is wrong?

View solution in original post

milindnikumbh
New Contributor III

Re: Product type wise sum is not showing for multiple currency

I do not want material / customer / currency dimensions in my table.

Wants product type / Qty / Vaue in  straight table.

Re: Product type wise sum is not showing for multiple currency

Also, same as in what? I see that A comes with the value 4.126 where as the original expression was null. How are they the same?

Re: Product type wise sum is not showing for multiple currency

Where do you see material / customer / currency dimension in the snap shot above?

Re: Product type wise sum is not showing for multiple currency

Did you even try to open the qvw attachment from my response above?

milindnikumbh
New Contributor III

Re: Product type wise sum is not showing for multiple currency

Thank you so much. Its resolved. What was the issue in my if statement .

Thanks a ton.

Re: Product type wise sum is not showing for multiple currency

Before I explain you the issue with your if statement, I would love to know how did the expression I gave not work for you? Did you even try it or just saw it and said nahh this isn't going to work?