Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! 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?

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')

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?

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