Discussion Board for collaboration on QlikView Scripting.
Why my raw data is 1259716.26 , but when i use sum(STK_OPEN) it display 30,051,204.06 ?
May i know how to make it display 1259716.26 when i use sum(OPEN_STK) ?
Go to Solution.
Seems like you have duplicate rows of data
One way to fix this is to use DISTINCT (sum(DISTINCT STK_OPEN)), but that won't work if each row have different values. Ideally you should fix this in the script itself.
what you are trying to achieve ?
I try to compute avg stock , and now I got this problem , I cannot tell you what I want to achieve.
Sent from my iPhone
Please check the frequency of STOCK_OPEN is list box. It's showing 31.
I think you need to aggregate your data in Sales_table
Paul please don't open new posts for the same issue.
I allready pointed out the fact that there are 31 value entries for dec in this post.
And it has been confirmed here again.
You should check your datamodel for duplicates or check the JOINs you use.