topic Re: How to display Bars? in QlikView

How to display Bars?

Sat, 06 Dec 2014 11:13:18 GMT

Hi ,

I have 4 years of sales and i created a bar chart for Present year sales,previous years sales month wise but i want to represent

present year sales according to month wise remaining all years sales i want to represent as a single bar.how to achieve it please guide me .

Thanks.

Re: How to display Bars?

alkesh_sharma — Sat, 06 Dec 2014 11:19:29 GMT

I this case you cannot use dimension. you need to add expression for every bar you want to create in the chart.

Re: How to display Bars?

ecolomer — Sat, 06 Dec 2014 11:33:16 GMT

Can you explain to me what you want to achieve exactly, please ?

Re: How to display Bars?

Sat, 06 Dec 2014 12:36:16 GMT

Thanks Enrique Colomer

I want to represent present year sales according to month wise[means for every month there should a bar] remaining all Previous years sales i want to represent as a single bar[means for all entire previous years should be one bar].

Please let me know for any additional information needed on the same.

Re: How to display Bars?

MarcoWedel — Sat, 06 Dec 2014 14:01:14 GMT

Maybe with some calculated dimension using valuelist or valueloop

Re: How to display Bars?

Sun, 07 Dec 2014 06:28:10 GMT

Hi Macro Wedel

Can"t we achieve it through Set analysis.

Re: How to display Bars?

nagaiank — Sun, 07 Dec 2014 07:02:43 GMT

Assuming that month field is defined by the date field Period (the month-start date of the data month), you may use the following calculated dimension.

If(Year(Period) <> '2014',Year(Period),MonthName(Period))

Also set the sort order to Period Ascending.

If your current year is not 2014, you may need to modify the expression depending on your data.

Re: How to display Bars?

Sun, 07 Dec 2014 15:21:39 GMT

Hi Nagaiank

If you don"t mind can you please provide an example on it how can we achieve the scenario.

Re: Re: How to display Bars?

nagaiank — Sun, 07 Dec 2014 15:46:54 GMT

An example is attached with dummy data that produces the following output. Hope this helps.

Re: How to display Bars?

Anonymous — Mon, 08 Dec 2014 00:43:11 GMT

It is cool..Nice one Nagaian

Re: How to display Bars?

Mon, 08 Dec 2014 05:41:18 GMT

Thanks Nagaiank,

in the above chart 2011,2012,2013 years data also it has to show in a single bar that is my scenario. i will work around it. thanks once again.

Re: Re: How to display Bars?

Anonymous — Mon, 08 Dec 2014 05:49:01 GMT

Hi John,

PFA. I have modified Nagaian qvw.

Ignore the QVW Name. I have created single bar only for all other years.

BR,

Chinna

Re: Re: How to display Bars?

its_anandrjs — Mon, 08 Dec 2014 06:11:24 GMT

Hi John,

You can try also for dynamically load the current year data as month wise and rest of the data as Year wise

1. First way

Dim:- =If(Year =Year(Today()),MonthName(Datefield),Year) //Calculated Dimension

Expre:- sum(sales)

2. Second Way

Dim:- =If(Year =Year(Today()),MonthName(Datefield),'All Year') //Calculated Dimension

Expre:- sum(sales)

Regards

Anand

Re: How to display Bars?

Mon, 08 Dec 2014 07:19:56 GMT

hi Chinna katiki

Thanks for your help.but i am using PE so i can't able to see your application.