topic Re: regd bar chart and its dimension values in QlikView

regd bar chart and its dimension values

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

The above chart has been generated in MS Excel. The same need to be implemented in Qlikview. Here I would like your help with how to plot dimension values on X-axis.

To be more clear, I have 2015 & 2016-YTD as "Year" but also followed by each Month(for e.g 2016-01) of the YTD year. In QV is it possible to plot on x-axis as single dimension with values of "Year" and "Month". I do not want to use multi dimension to achieve the same.

Please assist me with any sample qvw file so that it would be easy for me to understand the properties of the chart you develop.

Regards,

Message was edited by: Sabareesh Vysyaraju

Re: regd bar chart and its dimension values

sunny_talwar — Mon, 19 Jun 2017 12:35:35 GMT

May be you can use this to create and Month's on the same dimension

Period Presets: Compare Periods on the fly

For a better help, please provide a sample to work with.

Best,

Sunny

Re: regd bar chart and its dimension values

muraliqlik — Tue, 20 Jun 2017 05:29:10 GMT

Hi SV,

I have designed a way around for showing the chart you need

I may not be the best solutions but will work for your requirement.

PFA application.

Thanks

Murali !

Re: regd bar chart and its dimension values

Anonymous — Tue, 20 Jun 2017 06:38:40 GMT

Hi Sunny,

Thank you very much for the reference. As I work on Clients data I could not able to share the same over here. I referred to the link you have mentioned above. I am looking into it to modify accordingly to my requirement.

Regards,

SV.

Re: regd bar chart and its dimension values

Kushal_Chawda — Tue, 20 Jun 2017 12:25:52 GMT

You just have two years? what if data is for 3 years, how dimension should look like?

Re: regd bar chart and its dimension values

Anonymous — Tue, 20 Jun 2017 13:16:47 GMT

Hi Kushal,

I just specified a sample view of the chart.The requirement is to consider only the last 24 months of data.

Anyhow, if it is for 3 years, the dimensions should be like CurrentYear-2(aggregated) value, CurrentYear-1(aggregated) value, CurrentYear-YTD(aggregated value), followed by Month wise data for the current year,

Regards,

Re: regd bar chart and its dimension values

Kushal_Chawda — Tue, 20 Jun 2017 13:20:08 GMT

if you just want to compare Current Vs Previous in above format then follow below steps

Create variable on front end

vCurretYear =max(Year)

vPreviousYear =max(Year)-1

Data:

LOAD date(MakeDate('2014')+IterNo()-1) as Date,

ceil(Rand()*100)+1000 as Sales

AutoGenerate 1

While MakeDate('2014')+IterNo()-1 <=Today();

Calendar:

LOAD Date,

Year(Date) as Year,

YeartoDate(Date)*-1 as CurYTDFlag,

dual(Year(Date)&'-'& num(month(Date),00),Year(Date)&num(month(Date),00)) as Month

Resident Data;

Sort:

LOAD * Inline [

Order

3 ];

Create Bar chart

Dimension:

=Pick(Order,$(vPreviousYear),$(vCurretYear)&'-YTD',Month)

Expression:

=Pick(Order,

sum({<Year={"$(vPreviousYear)"}>}Sales),

sum({<CurYTDFlag={1}>}Sales),

sum({<Year={"$(vCurretYear)"}>}Sales))