topic Re: values not suming up in QlikView

values not suming up

saichawan — Wed, 25 Nov 2020 16:16:04 GMT

I have two data sets,for the first data set all values have been captured and accordingly the data is getting plotted. But when i'm loading the second data set. values are not summing up.

if i'm using a filter then all the values for that column are getting captured and when plotting a graph by suming same column used for filter is coming up to zero.

attached screenshot FYI. intial buy is the column name

Re: values not suming up

sunny_talwar — Mon, 16 Dec 2019 12:57:46 GMT

Would you be able to share a sample to check this out?

Re: values not suming up

saichawan — Mon, 16 Dec 2019 13:01:58 GMT

sample

Re: values not suming up

sunny_talwar — Mon, 16 Dec 2019 13:37:52 GMT

I think your issue is that you are joining the two tables on way too many fields then you might need. Do the values between the two tables need to match on TOT_SOH_QTY and RTL_QTY? They might... but it seems that this requires a match on those values as well...

Re: values not suming up

saichawan — Mon, 16 Dec 2019 13:49:33 GMT

Thanks a ton, it worked.

There is one more issue i'm facing.

i need to calculate rate of sale,number of units sold per week, for rolling and ytd. i'm using this formula but aint working out.

='Current Year:'& Num((Sum({<week = {">=$(vMinDate)<=$(vMaxdate)"}>} RTL_QTY)/Count(DISTINCT( week))/1000000),'##.00')
& ' Last Year:'&num((((Sum({<week = {">=$(vRollingStart)<=$(vRollingEnd)"},Period=>} RTL_QTY)/Count(DISTINCT( week))
-
Sum({<week = {">=$(vRollingStart)<=$(vRollingEnd)"},Period= {'LYTD'}> }RTL_QTY)/Count(DISTINCT( week)),'##.00')

Re: values not suming up

sunny_talwar — Mon, 16 Dec 2019 13:55:30 GMT

What is the issue you are seeing when you use the expression? Throws an error? Gives an incorrect number?

Re: values not suming up

saichawan — Mon, 16 Dec 2019 13:58:46 GMT

it throws a error

Re: values not suming up

sunny_talwar — Mon, 16 Dec 2019 14:02:51 GMT

1) Where have you used this expression in the attached dashboard?

2) Can you provide the updated app where you excluded the join between the two tables on TOT_SOH_QTY and RTL_QTY so that we are both looking at the same thing.

Re: values not suming up

saichawan — Mon, 16 Dec 2019 14:05:14 GMT

FYI

Re: values not suming up

sunny_talwar — Mon, 16 Dec 2019 14:14:02 GMT

Thanks, where is the expression which is throwing the error? What tab and what chart?

Re: values not suming up

saichawan — Mon, 16 Dec 2019 14:17:13 GMT

Sales tab, ros text object

Re: values not suming up

sunny_talwar — Mon, 16 Dec 2019 14:31:25 GMT

What number are you expect to see for Current Year and last Year in this text box? based on your selections?

Re: values not suming up

saichawan — Mon, 16 Dec 2019 14:39:35 GMT

if i select last year, then it shoould be retail quanity /52(number of weeks in a year). if i select current year from period filter, suppose current month is jan then calculation be like retail quantity/4(number of weeks in jan month) if current month is aug then calculation should be retail quanity/36(number weeks till august) and if the current month is oct then calculation be like retail quantity/40(number of weeks till oct) .

Re: values not suming up

saichawan — Tue, 17 Dec 2019 10:33:47 GMT

any help on this ??

Re: values not suming up

saichawan — Wed, 18 Dec 2019 07:01:07 GMT

waiting for your help

Re: values not suming up

Brett_Bleess — Mon, 23 Dec 2019 16:24:22 GMT

@sunny_talwar Just flagging this for Sunny, it can get difficult to keep track of everything, but this should do the trick hopefully, so he can have a last look. You can use the Accept as Solution button on the one post that got you the first part fixed, and once you get the latter, you can mark that one as well, I would not mark any until you have a complete answer though, reason I did not do the first one for you.

Cheers,
Brett