topic Re: Bucket do not return correct amount in QlikView

Bucket do not return correct amount

ashis — Sat, 16 Nov 2024 03:13:18 GMT

Hello, I am using a straight table and creating a calculated dimension using following syntax,

if(balance > 0 and balance <=200000, '>£0 - £200k',
if (balance > 200000 and balance <=400000, '>£200k - £400k',
if (balance > 400000 and balance <=600000, '>£400k - £600k',
if (balance > 600000 and balance <=800000, '>£600k - £800k',
if (balance > 800000 and balance <=1000000, '>£800k - £1m',
if (balance > 1000000, '>1m',
'<£0'))))))

and in expression using count(sales) .

Issue is the total amount it is rendering is incorrect, however when i do count(Distinct Sales) , it returns correct figure.

So somewhere in the above bucketing it is counting wrong (maybe more than one)

Is my above expression is correct .

Please advise.

Re: Bucket do not return correct amount

sunny_talwar — Fri, 21 Jun 2019 12:38:40 GMT

Do you need to bucket balance or do you need to bucket Sum(balance) based on some id? Difficult to know what might be the issue unless you share more details.

Re: Bucket do not return correct amount

ashis — Fri, 21 Jun 2019 13:47:58 GMT

Hi Sunny,

Thank you for your reply. I want to create bucket, then based on that bucket i want to count some property id ,ie

count(propertyid) .

I am not sure , presently the logic i am using is correct or not. Could you please validate if the logic is right.

Re: Bucket do not return correct amount

sunny_talwar — Fri, 21 Jun 2019 13:57:28 GMT

Validate how? I don't have data, I have no sample... what do you want me tell you my friend?

Re: Bucket do not return correct amount

ashis — Fri, 21 Jun 2019 14:07:29 GMT

Hi Sunny,

Validate means - what i mean to say the bucket syntax. If i use it similar fashion , should it work or it could count some duplicate records in the bucket. i have data restriction so afraid to share file.

I will explore more on it.

Thank you so much .

Re: Bucket do not return correct amount

sunny_talwar — Fri, 21 Jun 2019 14:18:01 GMT

Not really sure how I can help.... all the best!!