Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

In what situation QV user still using YTD Flag and not using SET ?

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

17 Replies
paulyeo11
Master
Master
Author

I though I have attach the QV sample file ? May be not send thru

Sent from my iPhone

jagan
Luminary Alumni
Luminary Alumni

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.

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

HI,

Try this.

money(

Sum({<Year=, Quarter=, Month=, Date={'>=$(=YearStart(Today(), -1))<=$(=Addyears(monthend(Today()),-1))'}>} $(ColumnDim51)/1000)

, $(vMoneyFormatK))

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
jagan
Luminary Alumni
Luminary Alumni

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.

paulyeo11
Master
Master
Author

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

Colin-Albert

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi Paul,

If you try my expression will get you 148 value.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
paulyeo11
Master
Master
Author

Look like this is correct value I looking for.

Thank you

Sent from my iPhone