Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
nithin_miryala
Creator
Creator

Expression formating error.

Hi Everyone,

I have expression which i put inside of the set analysis of the other expression.

=$(=Max(Total BaseDate))                                  Result: 43087


=Date(Max( Total BaseDate))                              Result: 2017-12-18 (Desired output)

=$(=Date(Max(Total BaseDate)))                        Result: 1987

I am unable to figure out what is wrong with last expression.

1 Solution

Accepted Solutions
sunny_talwar

1) I see an equal sign before the date

Capture.PNG

Are you still using {"=$(=Date(....))"}... Please remove it

2) Is your BaseDTS format 12-18-2017 or 12/18/2017? I think you need to understand the importance of format in set analysis. if the format doesn't match, the set analysis don't really work... so make sure you have this correct.

View solution in original post

16 Replies
sunny_talwar

I think the date is getting evaluated as subtraction 2017-12-18 = 1987.... but is this happening in set analysis? I think within set analysis it should work without any issues

{<BaseDate = {"$(=Date(Max(BaseDate)))"}>}

Note: No TOTAL needed within Max() function. Also, no = needed before Dollar sign expansion

sunny_talwar

Also check this

Dates in Set Analysis

nithin_miryala
Creator
Creator
Author

Even if i write like that.

That output value is 1987 not the desired output

luismadriz
Specialist
Specialist

Hi Sunny,

Great pick up that subtraction!!! It would've taken me ages to see it

Do you think that subtraction happened because of the = sign in front of the $ expansion?

=$(=Date(Max(Total BaseDate)))                        Result: 1987

=2017-12-18

mgavidia
Creator
Creator

You do not show your Set Analysis entry but it seems that what you are missing is the quotes.

Try this in your Set Analysis expression:

{"=Date(Max( Total BaseDate))"}

I don't think you need the TOTAL in your entry...

sunny_talwar

Would you be able to post a screenshot of your expression in a straight table without expression label and full expanded expression column, so that we can see what is the evaludated Date value within your expression

nithin_miryala
Creator
Creator
Author

Please look at the screenshot

Capture.JPG

the whole BaseDts is being ignored.  this expression is in Straight table

sunny_talwar

Did you miss the equal sign by mistake? And you added one before $? This is not what I mentioned, I mentioned the opposite of what you have done

Capture.PNG

{"$(=Date(...))"}

nithin_miryala
Creator
Creator
Author

I was testing things and forgot to remove it..

please look at the updated oneCapture.JPG

Still the result remain same. expression ignores the condition for BaseDTS and just taking the min of ThirdNextAvailableDts