Chart Expression

[dunnalahk123]

Hi,

Can Some one help me how can i add QoQ in first table next to last quarter

in above chart expression i just moved my Quarter dimension from vertical to column , so quarters coming as i needed.

but only one thing is i need to add QoQ end of that, i have the logic and expression ready .

but not sure how to add it. for your reference i am attaching qvw file . can some one help me please.

Best Regards,

hK

[sunny_talwar]

Added Only({1} ...) to the Dim after Pick... does the image below look like what you wanted?

Pick(Only({1}Dim),

...

[dunnalahk123]

Hi Sunny,

Thank you so much for your kind help.

Yes, I guess Quarter is function is working . 

but Year Function still not working and QoQ is gone with latest change.

but if some one select Q4 it should give Q4 Fy17 to Q4Fy16 which is 5 Quarters as we are still not in Q4 Fy18.

if some one select Q3 it should give me Q3Fy17 to Q3Fy16 which is 5 Quarters as we are still not in in Q3Fy18

So above is working as per your File for Quarter.

But

Year Function still not working and QoQ is gone with latest change.

in the same way if some one select directly FY17 from year in FY17 Max Quarter is Q4 so again it should give me Q4FY17 to Q4FY16.

in the same way if some one select directly FY18 from year in FY18 it should give current max quarter to back rolling of 5 Quarters.

So current max Quarter is Q1 So it should roll back to Q1FY18 to Q4FY17

Best Regards,

[sunny_talwar]

You can use set analysis for that. Look at this thread Dates in Set Analysis which will help you with set analysis on the date fields.