Last Quarter Data Population

[Anonymous]

Hi

I have a data in which i want the calculated field which has to show the current quarter information.

I have looked lots of post in qlik community but nothing is working out for me.Please suggest

[HirisH_V7]

At your Dimension in your chart ,

Supress when value is null()

one Quick question, is complete column is going Null??

-Hirish

[Anonymous]

Yeah everything is showing as null

[shraddha_g]

Did you refer app attached ?

[Anonymous]

Actually i have created a measure to calculate the current year summation which is  shown below.

sum({$<[PROCESSED_DT.autoCalendar.Year] = {'$(=date(max([PROCESSED_DT.autoCalendar.Year]), 'YYYY'))'},ROLLOVER_DESTINATION_TXT={'RTF','RTC'},FULL_DISTRIBUTION_IND={'Y'}>} ROLLED_TO_AMT)

do you have any suggestions to modify the same formula for quarter?

[HirisH_V7]

Use this,

IF(Ceil(Month(Today())/3)=Ceil(Month([Processed Date])/3),

sum({$<[PROCESSED_DT.autoCalendar.Year] = {'$(=date(max([PROCESSED_DT.autoCalendar.Year]), 'YYYY'))'},ROLLOVER_DESTINATION_TXT={'RTF','RTC'},FULL_DISTRIBUTION_IND={'Y'}>} ROLLED_TO_AMT)

)

HTH,

Hirish

[Anonymous]

again null

[Anonymous]

I have referred  your app....but that is not working out for me

[Anonymous]

Its showing the summation of entire RTA data

[shraddha_g]

Instead of sum() ypu can use only() there

[Anonymous]

again null