topic Re: Expression formating error. in QlikView

Expression formating error.

nithin_miryala — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Expression formating error.

sunny_talwar — Thu, 28 Dec 2017 22:27:53 GMT

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

Re: Expression formating error.

sunny_talwar — Thu, 28 Dec 2017 22:28:23 GMT

Also check this

Dates in Set Analysis

Re: Expression formating error.

nithin_miryala — Thu, 28 Dec 2017 22:34:08 GMT

Even if i write like that.

That output value is 1987 not the desired output

Re: Expression formating error.

luismadriz — Thu, 28 Dec 2017 22:37:14 GMT

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

Re: Expression formating error.

mgavidia — Thu, 28 Dec 2017 22:41:00 GMT

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

Re: Expression formating error.

sunny_talwar — Thu, 28 Dec 2017 22:41:45 GMT

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

Re: Expression formating error.

nithin_miryala — Thu, 28 Dec 2017 22:53:40 GMT

Please look at the screenshot

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

Re: Expression formating error.

sunny_talwar — Thu, 28 Dec 2017 22:57:52 GMT

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

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

Re: Expression formating error.

nithin_miryala — Thu, 28 Dec 2017 23:04:44 GMT

I was testing things and forgot to remove it..

please look at the updated one

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

Re: Expression formating error.

nithin_miryala — Thu, 28 Dec 2017 23:05:09 GMT

Even if i remove that it doesnt work as required.

Re: Expression formating error.

sunny_talwar — Thu, 28 Dec 2017 23:09:00 GMT

Can you actually post the screenshot of the chart (instead of expression editor) to show what it shows in the label section of the expression?

Essentially, I want to see this

Expression in the expression label (make sure you have removed any label names from the expression label on the expressions tab

Re: Expression formating error.

nithin_miryala — Fri, 29 Dec 2017 14:43:53 GMT

Here is the screen shot. of what the expression label says.

When i go and select the 12/18/2017 in the BaseDTS the values look like this and This is the desired output.

Re: Expression formating error.

sunny_talwar — Fri, 29 Dec 2017 14:47:23 GMT

1) I see an equal sign before the date

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.

Re: Expression formating error.

nithin_miryala — Fri, 29 Dec 2017 15:08:34 GMT

Formatting was the issue. Sorry for the whole trouble

Re: Expression formating error.

sunny_talwar — Fri, 29 Dec 2017 15:12:37 GMT

Def. suggest you to read this... you will love it

Dates in Set Analysis

Re: Expression formating error.

nithin_miryala — Fri, 29 Dec 2017 15:23:58 GMT

Sure Thanks