REGARDING SOME CALCULATION

[qliksus]

Hi,

Just open the qvw file there u can see i am facing problem in getting sum.

Waiting for reply??????

[#2 · Accepted solution]

Try this..

Sum({$<closingstock={">0"}>} Sale)

When you use the if-statements, you will often multiply you your rows when your conditinal sum depends on a value from another table.

This was not an issue up to version 8, but from 8.5 and onwards, it seems like the only thing that handle this correctly is "Set analysis"

/Martin

[qliksus]

Hi,

Thanks for reply. It's works fine .