Announcements
Product Release Webinar: Qlik Insider airing December 6! REGISTER TODAY!
cancel
Showing results for
Did you mean:
Creator

## chart with year,qty and month as columns

Hi All,

I want to display the chart like below, need the previous two years,  quarters in the current year and months in the current quarter.

Labels (3)

• ### Quarter display

1 Solution

Accepted Solutions
Creator
Author

i have achieved the solution.

to achieve this, I wore a couple of calculated dimensions. please find below.

1.Year_supplier

2.=if(year([SCO Released Date])=\$(=vCurrent_year_supplier),if(len([SCO Released Date])<>0, 'Q'& ceil(month([SCO Released Date])/3)),Null())

vCurrent_year_supplier = max(Year_supplier)

3.=if(year([SCO Released Date])=\$(=vCurrent_year_supplier),if(ceil(month([SCO Released Date])/3)=\$(=vMax_quarter_supplier),Month_Supplier,null()),null())

vMax_quarter_supplier =max({<Year_supplier={\$(=max(Year_supplier))}>}Quarter_supplier)

4.Company_site

to ristrict the data to previous two year, wrote set analysis in expression.

avg({<Year_supplier={'>=\$(=vPrevious_2years_supplier)<=\$(=vCurrent_year_supplier)'}>} [Review Score])

Hope it helps.

Regards,

Sra1..

3 Replies
Specialist

Hello!

PFA.

[
dim
1
2
3
];

After that, you can assign different calculations for each value of dim.

Yes, the result is little bit different of your expected output (there is no combined columns like Year-Quart, Quart-Month). But you can achive this by yourself if you'll have more workaround on if-conditions in dimensions/expressions.

Hope this is it.

Creator
Author

i have achieved the solution.

to achieve this, I wore a couple of calculated dimensions. please find below.

1.Year_supplier

2.=if(year([SCO Released Date])=\$(=vCurrent_year_supplier),if(len([SCO Released Date])<>0, 'Q'& ceil(month([SCO Released Date])/3)),Null())

vCurrent_year_supplier = max(Year_supplier)

3.=if(year([SCO Released Date])=\$(=vCurrent_year_supplier),if(ceil(month([SCO Released Date])/3)=\$(=vMax_quarter_supplier),Month_Supplier,null()),null())

vMax_quarter_supplier =max({<Year_supplier={\$(=max(Year_supplier))}>}Quarter_supplier)

4.Company_site

to ristrict the data to previous two year, wrote set analysis in expression.

avg({<Year_supplier={'>=\$(=vPrevious_2years_supplier)<=\$(=vCurrent_year_supplier)'}>} [Review Score])

Hope it helps.

Regards,

Sra1..

Creator
Author

I need totals for each and every column, but i could not get the totals. can someone help to get the totals?

Community Browser