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

[Anonymous]

Hi Guys,

Any other suggestion

[shraddha_g]

working at my side.

if possible provide data model screenshot.

Or scramble data and provide sample app

[HirisH_V7]

Hi surya,

Please create sample app, with some sample data.

and address your issue.

[Anonymous]

Hi guys,

I have used the below calculated field which is showing Q4 data.but i want to show the Q3 information. Please suggest

sum({<QuarterStart = {"$(=max(QuarterStart))"},ROLLOVER_DESTINATION_TXT={'RTF','RTC'},FULL_DISTRIBUTION_IND={'Y'}>}ROLLED_TO_AMT)

[HirisH_V7]

sum({<QuarterStart = {"$(=max(QuarterStart)-1)"},ROLLOVER_DESTINATION_TXT={'RTF','RTC'},FULL_DISTRIBUTION_IND={'Y'}>}ROLLED_TO_AMT)

Check this.

[shraddha_g · Accepted solution]

Try,

sum({<QuarterStart = {"$(=date(addmonths(max(QuarterStart),-3)))"},ROLLOVER_DESTINATION_TXT={'RTF','RTC'},FULL_DISTRIBUTION_IND={'Y'}>}ROLLED_TO_AMT)

[Anonymous]

Tanq alot Shraddha...Its worked out

[shraddha_g]

Great!