
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Getting absurd behavior of set analysis in Qlik sense
Hi All ,
I applying set analysis statement in qlik sense .
but it is giving me 0 value .
where as I have number in applied date range also I checked same statement in qlikview ,It is working perfectly .
Please verify below mentioned statement and correct me If I missed something.
SUM({<POHistoryDate={">=27/11/2015<=27/11/2015"}>}POHistoryCount)
sum({< POHistoryDate = {">=$(=vStartDate)<= $(=vEndDate)"} >}POHistoryCount)
Thanks in advanced
Chanchal
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi All ,
I am really very thank full to all of you for your quick answers.
As understand my problem .
I am passing the Date value through Extension object ,in Set statement showing 27/11/2015 ,But it is not considering that value as date . When I tried this value to convert into the number it is showing me : <.0012181367020077> instead of <42335 > .
So I got the actual reason of my problem and solve it through passing the value like '27/11/2015' instead of 27/11/2015 .
Thanks & Regards
Chanchal .

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try with single quotes like:
SUM({<POHistoryDate={'>=27/11/2015<=27/11/2015'}>}POHistoryCount)
Assuming the dates in your date field are of similar (i.e.-DD/MM/YYYY) format.

.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
The date format of POHistoryDate field and variables vStartDate and vEndDate should be in same format. Then only below expression works.
sum({< POHistoryDate = {">=$(=vStartDate)<= $(=vEndDate)"} >}POHistoryCount)
Hope this helps you.
Regards,
Jagan.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
I just encountered same error, maybe you can try to use date() function:
sum({< POHistoryDate = {">=$(=date(vStartDate))<= $(=date(vEndDate))"} >}POHistoryCount)
Thanks and Regards.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Sharma,
Even With out the = sign it should work fine.
Try this:
sum({< POHistoryDate = {">= $(vStartDate)<= $(vEndDate)"} >}POHistoryCount)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi All ,
I am really very thank full to all of you for your quick answers.
As understand my problem .
I am passing the Date value through Extension object ,in Set statement showing 27/11/2015 ,But it is not considering that value as date . When I tried this value to convert into the number it is showing me : <.0012181367020077> instead of <42335 > .
So I got the actual reason of my problem and solve it through passing the value like '27/11/2015' instead of 27/11/2015 .
Thanks & Regards
Chanchal .
