topic Re: Bar chart limit in QlikView

Bar chart limit

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

i have 24 months in barchart.

but want to show last 12 months only

how to limit the dimension?

PFA

Re: Bar chart limit

Digvijay_Singh — Thu, 03 Mar 2016 06:25:51 GMT

You can use set analysis in expression something like Sum({<Month = {">=$(=Max(Month)-12)"}>}Value)

Re: Bar chart limit

amit_saini — Thu, 03 Mar 2016 06:28:29 GMT

Hi,

PFA

Thanks,

Re: Bar chart limit

t_chetirbok — Thu, 03 Mar 2016 06:33:31 GMT

Hello!

try this set analysis: sum({<DATE={">=$(=addmonths(max({1}DATE),-11))"}>} VALUE)

Re: Bar chart limit

stephenedberkg — Thu, 03 Mar 2016 06:36:00 GMT

Dear Digvijay

if i selected the Week 15 mean i have the 24 weeks

but 1 st 12 weeks are history weeks last 12 weeks are forecast weeks

i want to show the last 12 weeks only

my expression is

=num(sum({<Year_UP = {$(=Max(Year_UP))},Week_UP={$(=Max(Week_UP))}>}Sales),0.00)

Re: Bar chart limit

Anonymous — Thu, 03 Mar 2016 06:36:07 GMT

I think you should check this, every thing is mentioned here?

Set Analysis for certain Point in Time

Set Analysis for Rolling Periods

Re: Bar chart limit

stephenedberkg — Thu, 03 Mar 2016 06:36:52 GMT

Dear amit.saini

i am using personal edition only so i cant open your QVW files

Re: Bar chart limit

ecolomer — Thu, 03 Mar 2016 06:36:55 GMT

Select limit of values:

Re: Bar chart limit

Anonymous — Thu, 03 Mar 2016 06:38:39 GMT

Go to dimension limit select option and the give the value there than it show only that values .

Re: Bar chart limit

stephenedberkg — Thu, 03 Mar 2016 06:39:08 GMT

i want to show last 12 weeks only

Re: Bar chart limit

stephenedberkg — Thu, 03 Mar 2016 06:40:13 GMT

if i selected the Week 15 mean i have the 24 weeks

but 1 st 12 weeks are history weeks last 12 weeks are forecast weeks

i want to show the last 12 weeks only

my expression is

=num(sum({<Year_UP = {$(=Max(Year_UP))},Week_UP={$(=Max(Week_UP))}>}Sales),0.00)

Re: Bar chart limit

ecolomer — Thu, 03 Mar 2016 06:43:56 GMT

See this example

Re: Bar chart limit

Anonymous — Thu, 03 Mar 2016 06:45:02 GMT

did you check what I shared with you?

Re: Bar chart limit

Digvijay_Singh — Thu, 03 Mar 2016 06:47:32 GMT

Not sure but in your question you had mentioned 12 months, if you want last 12 weeks, and I can see you have week field in your model, did you try this -

=num(sum({<Year_UP = {$(=Max(Year_UP))},Week_UP={">=$(=Max(Week_UP)-12)"}>}Sales),0.00)

Re: Bar chart limit

stephenedberkg — Thu, 03 Mar 2016 06:48:48 GMT

i don't want to modify the expression

i want to change the dimension limit

Re: Bar chart limit

amit_saini — Thu, 03 Mar 2016 06:48:50 GMT

Check:

Script:

Sample_Int:

LOAD * INLINE [

Month, Sales

Jan-09, 55

Feb-09, 39

Mar-09, 33

Apr-09, 56

May-09, 55

Jun-09, 70

Jul-09, 57

Aug-09, 29

Sep-09, 34

Oct-09, 41

Nov-09, 12

Dec-09, 11

Jan-10, 24

Feb-10, 85

Mar-10, 99

Apr-10, 77

May-10, 85

Jun-10, 64

Jul-10, 61

Aug-10, 45

Sep-10, 62

Oct-10, 70

Nov-10, 59

Dec-10, 25

Jan-11, 86

Feb-11, 92

Mar-11, 67

Apr-11, 65

May-11, 39

Jun-11, 70

];

Sample:

Load

Date(Date(Date#(Month,'MMM-YY'),'DD-MM-YYYY'),'MMM-YY') as YearMonth,

Sales

Resident Sample_Int;

Drop Table Sample_Int;

For bar chart :

Dimension : YearMonth

Expresii: Sum({<YearMonth ={">=$(=Date(addmonths(Max(YearMonth), -12), 'MMM-YY')) <=$(=Date(addmonths(Max(YearMonth), -1), 'MMM-YY'))"} >} Sales)

Thanks,

Re: Bar chart limit

stephenedberkg — Thu, 03 Mar 2016 06:49:36 GMT

i have personal edition so i cant open the QVW files

Re: Bar chart limit

stephenedberkg — Thu, 03 Mar 2016 06:50:11 GMT

if i selected the Week 15 mean i have the 24 weeks

but 1 st 12 weeks are history weeks last 12 weeks are forecast weeks

i want to show the last 12 weeks only

my expression is

=num(sum({<Year_UP = {$(=Max(Year_UP))},Week_UP={$(=Max(Week_UP))}>}Sales),0.00)

Re: Bar chart limit

tyagishaila — Thu, 03 Mar 2016 06:50:57 GMT

Sort your Dimension in descending order and then apply dimension limit

first 12.

or you can use

Presentation Tab--> Enable X-axis Scrollbar [12] ---> check Reversed

Re: Bar chart limit

Anonymous — Thu, 03 Mar 2016 06:52:03 GMT

Through Dimension Limit I do not think you can fetch last 12 month data.

Dimension Limits are used when you want to show max or min value not for last 12 month Data.

I think Set Analysis is a better option for same