topic Re: Implementing floor conditon to datefield in set expression in QlikView

Implementing floor conditon to datefield in set expression

Fri, 13 May 2016 04:07:26 GMT

hi guys,

floor(AddYears(max(DateNum),-1))-floor(AddYears(min(DateNum),-1))+1

i want to implement the above condition in set expression...

=sum({<Salesfy={$(=max(Salesfy)-1)},Datenum={"$(=floor(AddYears(max(DateNum),-1))-floor(AddYears(min(DateNum),-1))+1) "}>}GROSSWEIGHT)

please correct above expression

i just writing this expression to previous year salesGrossweight for the selected dates in the current year

Re: Implementing floor conditon to datefield in set expression

tresB — Fri, 13 May 2016 04:50:44 GMT

What is the issue you are facing? Could you explain and share your sample qvw?

Re: Implementing floor conditon to datefield in set expression

Fri, 13 May 2016 04:57:24 GMT

I want to see the previous selected days count

Can you please correct the set expression which given in above

Re: Implementing floor conditon to datefield in set expression

tresB — Fri, 13 May 2016 05:03:12 GMT

Your expression at first look seems to be right in syntax. But that assurance alone perhaps doesn't help you much. I guess, you have to explain it a bit more in details. Providing a sample to work on is a great help for people who want to help you here.

Re: Implementing floor conditon to datefield in set expression

PrashantSangle — Fri, 13 May 2016 05:18:51 GMT

Hi,

looks like your expression is correct. issue with DateNum field

just confirm that you are rounding DateNum field in setAnalysis

floor(AddYears(max(DateNum),-1))

and your compare field Datenum is not rounded so you are not getting correct result.

for example

11 is not equal to 11.2

Also check qlikview is case sensitive therefore Datenum and DateNum is same field or not

Kind Regards

Re: Implementing floor conditon to datefield in set expression

Fri, 13 May 2016 06:27:05 GMT

sorry small mistake i did let me try once...

thank you