topic Re: Bar Chart in QlikView

Bar Chart

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

I want to create a Bar Chart with four bars. There is one Dimension for ex. Date and one measure for ex. Sales. Now in Bar chart first bar shows the sales for current month. Second bar shows the sales for MTD, third Bar shows the sales for YTD and Fourth bar shows the sales for Quarter year.

Please can anyone suggest a way to do that?

Re: Bar Chart

tresB — Tue, 20 Feb 2018 07:08:42 GMT

Try using synthetic dimension, like:

Dim: ValueList('Curr Month Sales', 'MTD', 'YTD', 'QTD')

Exp: Pick(Match(ValueList('Curr Month Sales', 'MTD', 'YTD', 'QTD'), 'Curr Month Sales', 'MTD', 'YTD', 'QTD'),

<Exp for Curr Month Sales>, <Exp for MTD>, <Exp for YTD>, <Exp for QTD>)

Re: Bar Chart

d_ankusha — Tue, 20 Feb 2018 07:19:04 GMT

Thank you