Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
There can be few things
1) Is FromDate read correctly by Qlik Sense?
2) Are the formats on LHS and RHS the same?
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
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
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.
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.