Showing data on bar chart as per requirement

[deepakqlikview_123]

Hi All,

Below is scenario,

I hve 2 FRQ Types A and Q

For FRQ type Q i have four quarters Q1, Q2,Q3 and Q4 and for FRQ type A i have Quarter Q4

i need to plot indicator value as per indicator name.

Each year i need to show indicator value FRQ type A(Q4 for FRQ type A).

only for each max year as per indicator name i need to show all quarters for FRQ type Q.

I have attached sample application.

Can you please suggest how shall i go ahead.

Thanks

[settu_periasamy]

Hi,

do you want like the below screen shot

if so, try to change your year dimension as a Calculated dimension. put the expression like the below

     =if(YEAR=$(vYear),YEAR&' '&QUARTER,YEAR)

may be this would be helpful.

[deepakqlikview_123]

Hi,

Thanks, my output should be same like this but

if all years excepting max year FRQ type should A and for max year FRQ type should Q

for 1 indicator name only not for more than 1 indicator

thanks

[settu_periasamy]

Hi,

if i understand correctly, It is showing like that your requirement.

see the below screen shot in straight table.

[deepakqlikview_123]

Hi Settu,

Thanks for response shall we make it dynamically for each max year.and only for 1 indicator not more than one

Thanks

[settu_periasamy]

sorry deepak, not getting your point..

only for 1 indicator means?

[deepakqlikview_123]

hi,

thanks for response this is very helpful for me

for indicator name % of non bank private need to show year for frq type A and quarters for FRQ type Q for max year and for remaining years only FRQ type A indicator value.

thanks

[settu_periasamy · Accepted solution]

Hi,

try this in your 2nd expression(Frq A)

=sum({<YEAR-={'$(vYear)'},FRQ_TYPE={'A'},INDICATOR_NAME={'% of Non-Bank Private Debt to Nominal GDP'}>}INDICATOR_VALUE)

the straight table looks like below

hope this would be helpful.