Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
May i know the answer from QV developer ?
Or I re-phase the questions , what are the YTD Flag is not able replace by SET Analysis ?
The reasons i ask this question is because , if the answer of above is No , i like to know why YTD Flag is so powerfull which unable to replace by SET.
For example , in QS , i use YTD and not SET Analysis , because QS is not encourage user to click on month = current month and year = current year.
Paul
I though I have attach the QV sample file ? May be not send thru
Sent from my iPhone
Hi Paul,
I checked your file and tested like below
Selection: Year = 15
Expression:
=money(Sum( $(ColumnDim51)/1000), $(vMoneyFormatK))
And the result is 802K.
I think there is no issue in the expression, the number is correct.
Regards,
jagan.
HI,
Try this.
money(
Sum({<Year=, Quarter=, Month=, Date={'>=$(=YearStart(Today(), -1))<=$(=Addyears(monthend(Today()),-1))'}>} $(ColumnDim51)/1000)
, $(vMoneyFormatK))
Regards,
Kaushik Solanki
If you just want upto Feb 2015 then use below expression
money(
Sum({<Year=, Quarter=, Month=, Date={'>=$(=YearStart(Today(), -1))<=$(=MonthEnd(Today(),-12))'}>} $(ColumnDim51)/1000)
, $(vMoneyFormatK))
Hope this helps you.
Regards,
Jagan.
Hi Kau
Thank you for sharing , as I notice your expression is diff from Jagon .
And Since Jagon said his expression is correct and getting 801 is correct , may I know your expression get what value ?
Paul
Sent from my iPhone
Have a look at this post Optimize UI Performance with Flags and Set Analysis
Hi Paul,
If you try my expression will get you 148 value.
Regards,
Kaushik Solanki
Look like this is correct value I looking for.
Thank you
Sent from my iPhone