Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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
Highlighted

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

Highlighted

Also check this

Dates in Set Analysis

Highlighted
Creator
Creator

Even if i write like that.

That output value is 1987 not the desired output

Highlighted
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

Highlighted
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...

Highlighted

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

Highlighted
Creator
Creator

Please look at the screenshot

Capture.JPG

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

Highlighted

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(...))"}

Highlighted
Creator
Creator

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