Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
rittermd
Master
Master

Expression Help

What is wrong with this expression?

Sum({<$(vTTLStartDate)={'4/1/2015'}>}((DCrating - AdmitRating) * NumGoal))

/

Sum({<$(vTTLStartDate)={'4/1/2015'}>} NumGoal)

I have confirmed that the variable does contain 4/1/2015.  The variable was created by taking the Min of a date field.

14 Replies
rittermd
Master
Master
Author

That still returns nothing.  Just a '-'

Not even a zero.

This shouldn't be this difficult.

I can replace the date logic with just looking for a certain value in another field and it works. But checking dates is just not working.

sunny_talwar

There can be few things

1) Is FromDate read correctly by Qlik Sense?

Why don’t my dates work?

Get the Dates Right

2) Are the formats on LHS and RHS the same?

Dates in Set Analysis

3) Does your shows date of text format?

It would be easier to help (and guide) if we have a sample to look at. Otherwise, it is going to be all guesswork

rittermd
Master
Master
Author

I create the variable as follows

Min(Date(FromDate,'M/D/YYYY'))

I updated your last expression to

Date(FromDate,'M/D/YYYY') on the LHS

I created text objects to display each and they match up visually any way.

It doesn't make sense to me that they don't match in the expression

sunny_talwar

Mark Ritter wrote:

I updated your last expression to

Date(FromDate,'M/D/YYYY') on the LHS

You cannot make modifications (using functions) on the LHS of the equation. Whatever modifications needed, will have to be made on the RHS.

rittermd
Master
Master
Author

Tell me if this makes any sense?

I think the problem is that the FromDate is empty until I select it as a filter. 

I created an expression: If ($(vTTLStartDate)=$(vFromDate),1,0)

It displays a zero if I don't select the FromDate from the dashboard.  If I do select 4/1/2015 then it shows a 1.

So this makes me think about what I am even trying to do.  My client doesn't really want an interactive dashboard (or sheet).  I am pulling in a group of records from a stored procedure that is run multiple time with different parameters.  The output contains records for FromDate 03/01/2016 and FromDate(04/01/2015).  The first set of data is the current month.  The second set is the past 12 months. 

What I want to do is just create a sheet that shows measures based on the rows with each date.  So one set for 3/1/2016 and another set for 4/1/2015.  With no selection made by the user.  This would be a static sheet.

Is that even possible to do in Qlik Sense.