Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

regd bar chart and its dimension values

Hi All,

Sample.png

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,

SV

Message was edited by: Sabareesh Vysyaraju

6 Replies
Highlighted

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

Highlighted
Contributor II
Contributor II

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 !

Highlighted
Contributor II
Contributor II

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.

Highlighted
MVP
MVP

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

Contributor II
Contributor II

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,

SV

Highlighted
MVP
MVP

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

1

2

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

Capture.JPG