Solved: Showing data on bar chart as per requirement - Qlik Community

deepakqlikview_123 · ‎2015-06-23

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 · ‎2015-06-26

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.

sujeetsingh · ‎2015-06-24

Please come in more words .

deepakqlikview_123 · ‎2015-06-24

I need to show all quarters for FRQ type Q(Q1,Q2,Q3,Q4) for max year otherwise i need to show Q4 for FRQ type A for all years.

Thanks

Anonymous · ‎2015-06-24

Hello,

PFA,

I am not clear with the req, however, I made something out of what I understood. If it's right then add some cosmetics to the chart.

HTH.

deepakqlikview_123 · ‎2015-06-24

Hi

if suppose i have years from 2001 to 2014.

Then i need to show data for FRQ type A till 2013 and for 2014 all quarters for FRQ type Q(all quarters Q1 Q2 Q3 Q4)

Anonymous · ‎2015-06-24

Check this

deepakqlikview_123 · ‎2015-06-24

Hi,

Please find attached image.I need to show data for all quarters for max year for FRQ type Q.

For all years except max year i need to show data for FRQ type A(Annually)

Thanks

deepakqlikview_123 · ‎2015-06-24

Hi All,

Can you please suggest on this.

Thanks

sujeetsingh · ‎2015-06-25

You need to make a New Field which is combination of both Year and Quarter

deepakqlikview_123 · ‎2015-06-25

Thanks Sujeet,

But can you please suggest more on this.

Thanks