Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Sir
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) ?
Paul
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 ?
Vikas
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.
Hi Sir
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.
https://community.qlik.com/message/942162?et=watches.email.thread#942162
And it has been confirmed here again.
You should check your datamodel for duplicates or check the JOINs you use.