Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

How to display Bars?

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.

1 Solution

Accepted Solutions
nagaiank
Valued Contributor III

Re: How to display Bars?

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.

View solution in original post

13 Replies
alkesh_sharma
Contributor III

Re: How to display Bars?

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

ecolomer
Honored Contributor II

Re: How to display Bars?

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

Not applicable

Re: How to display Bars?

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?

Maybe with some calculated dimension using valuelist or valueloop

Not applicable

Re: How to display Bars?

Hi Macro Wedel

Can"t we achieve it through Set analysis.

nagaiank
Valued Contributor III

Re: How to display Bars?

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.

View solution in original post

Not applicable

Re: How to display Bars?

Hi Nagaiank

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

nagaiank
Valued Contributor III

Re: Re: How to display Bars?

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

chinnakatikisg
Valued Contributor

Re: How to display Bars?

It is cool..Nice one Nagaian