topic Re: expression showing zero value in QlikView

expression showing zero value

pradosh_thakur — Fri, 08 Dec 2017 09:37:52 GMT

=sum({<[Invoice Period]={" $(=date(MAX([Invoice Period]),'YYYY-MM'))"}>}[Actual Total]) is working but

=sum({<[Invoice Period]={"<= $(=date(MAX([Invoice Period]),'YYYY-MM'))"}>}[Actual Total]) is showing zero

object : textbox

tool :qlikview 12.x

regards

Pradosh

Re: expression showing zero value

Chanty4u — Fri, 08 Dec 2017 09:41:54 GMT

try this

what is the date format ?

=sum({<[Invoice Period]={'<= $(=date(MAX([Invoice Period]),'YYYY-MM'))'}>} Dsiticnt [Actual Total])

Re: expression showing zero value

tresB — Fri, 08 Dec 2017 09:42:06 GMT

This could be because your YYYY-MM formatted [Invoice Period] is possibly a text field. Text field comparison could work with '=' but not really with '<='. Ideally, you should create a dual date field in the script.

Re: expression showing zero value

Anil_Babu_Samineni — Fri, 08 Dec 2017 09:42:13 GMT

In fact, I thought same earlier, I thought to ask stalwar1‌ or hic fortunately i missed that. Someway, I got to know the issue

=sum({<[Invoice Period]={"<=$(=date(MAX([Invoice Period]),'YYYY-MM'))"}>}[Actual Total]) is showing zero

Here, What i understand is Set analysis with some spaces won't allow. If you remove i believe this should work. Not really sure what is the cause..

Re: expression showing zero value

pradosh_thakur — Fri, 08 Dec 2017 09:52:52 GMT

Thank you for your suggestion.

It's a date and it is working fine now after i followed Anil's suggestion and removed the space.

strange!!

regards

Pradosh

Re: expression showing zero value

pradosh_thakur — Fri, 08 Dec 2017 09:54:09 GMT

Strange !! thats the case here. I have never encountered this bug(if it is a bug) before. its working fine now Anil. let me experiment a little and i will close the thread.

regards

Pradosh

Re: expression showing zero value

sunny_talwar — Fri, 08 Dec 2017 12:11:01 GMT

Yes, Anil is right, for some reason spaces after <=, <, >, >= and before $() cause the expression to now work.... so don't have them

Re: expression showing zero value

Anil_Babu_Samineni — Fri, 08 Dec 2017 12:30:46 GMT

Any reason, What it could be and If we use in script looks like we've got as expected like

If(Field <= 10, 1,0)

Re: expression showing zero value

sunny_talwar — Fri, 08 Dec 2017 12:47:16 GMT

So, let me clarify... the issue is related to spaces in set analysis... for example

Sum({<Number = {"> 10 < 15"}>} Sales)

Sum({<Number = {">10<15"}>} Sales)

I have not done any testing, but I think first expression won't work because of spaces, while the second one will... when I say it won't work, I mean it will just ignore set analysis on Number field....