topic Re: chart with year,qty and month as columns in QlikView

chart with year,qty and month as columns

Navars — Sat, 16 Nov 2024 01:07:51 GMT

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.

Thanks in Advance..

Re: chart with year,qty and month as columns

Sergey_Shuklin — Thu, 05 Mar 2020 13:12:03 GMT

Hello!

PFA.

You can load hardcoded table with additional dimensions:

LOAD * Inline
[
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.

Re: chart with year,qty and month as columns

Navars — Thu, 12 Mar 2020 19:11:23 GMT

Thanks for your reply.

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..

Re: chart with year,qty and month as columns

Navars — Thu, 12 Mar 2020 19:19:31 GMT

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