topic Re: Bar Chart in QlikView

Bar Chart

mario-sarkis — Wed, 01 Jul 2015 07:54:33 GMT

hey all

i have a Bar Chart with its dimenssion a YearMonth i need to show only the last six month how can i do it in Bar Chart ?

hope you can help thank you,

Re: Bar Chart

SatyaPaleti — Wed, 01 Jul 2015 08:02:19 GMT

Hi Mario,

go to Chart Properties --> Sort --> Keep --> Dimension(YearMonth ) in Descending order and again go to Dimenion Limits in Propeties --> there is a option called (Restrict which valuees are displayed) check it that box and below to that you can find a option called (show only) just drop down it and select option from that

Hope it will works

Thank you,

Satya paleti

Re: Bar Chart

Anonymous — Wed, 01 Jul 2015 08:05:39 GMT

check this link and adjust the set analysis based on your requirement

Relative Calendar Fields

Re: Bar Chart

MK_QSL — Wed, 01 Jul 2015 08:25:06 GMT

Sample

Create Bar Chart

Dimension

InvoiceMonth

Expression

SUM({<

InvoiceMonth = , InvoiceMonthYear =, InvoiceQuarter = , InvoiceYear = ,

InvoiceDate = {">=$(=MonthStart(Max(InvoiceDate),-5))<=$(=Max(InvoiceDate))"}

Sales)

Re: Bar Chart

vardhancse — Wed, 01 Jul 2015 08:48:23 GMT

Chart Properties->Dimensional Limits->Show only