Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I have 2 date ranger pickers to set the start and end date as variables.
I have an expression that uses these variables to filter the data.
sum({<[Date1] = {'>=$(=Date(v_DateFilterStart))<=$(=Date(v_DateFilterEnd))'} >} CALCVOLUME)
The need: I want to create a line graph that has a Date1 dimension and the above expression. But have the Date1 dimension be filtered by what is selected from the date pickers.
Any help on how to get this dimension to reflect the variables.
Then try this
Sum({<[Date1] = {">=$(=Date(v_DateFilterStart, 'MM/DD/YYYY'))<=$(=Date(v_DateFilterEnd, 'MM/DD/YYYY'))"}>} CALCVOLUME)
Note: Make sure to use Double quotes instead of single quote.....
What do you get when you use this in a text box object?
='>=' & Date(v_DateFilterStart) & '<=' & Date(v_DateFilterEnd)
Does this give you the correct date range (based on the selection) and the format which matchs Date1's format?
Yes it shows >=01/01/2017<=3/11/2018
Is this the same format as the Date1... also does it give >=01/01/2017<=03/11/2018 or >=1/1/2017<=3/11/2018.... essentially, is it M/D/YYYY or MM/DD/YYYY? And what is the format of Date1?
M/D/YYYY sorry. And Date1 is MM/DD/YYYY
Then try this
Sum({<[Date1] = {">=$(=Date(v_DateFilterStart, 'MM/DD/YYYY'))<=$(=Date(v_DateFilterEnd, 'MM/DD/YYYY'))"}>} CALCVOLUME)
Note: Make sure to use Double quotes instead of single quote.....