Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

panipat1990
Contributor II

Help

Hi Team,

I have a requirement.i have a data from 2000 to 2016.. i want to make stacked bar chart where i want to show in dimension field in year from 2012 to 2016..but in 2012 bar show sum of 2000 to 2011 Value in half bar .and other half bar 2012 value...same as 2013,2014,2015,2016 ..... for this  i am sharing excel where value from 2000 to 2016 ...kindly help me.

Year            Id

2000            1

2001            2

2002            3

2003            4

2004             5

2005             6

2006             7

2007             8

2008             9

2009            10

2010             11

2011               12

2012              13

2013                 14

2014                15

2015                 16

2016                 17

When i select on 2012 then it show count of id from 2000 to 20111 in half bar ..other half bar show 2012 value like 13....same as 2013,2014

19 Replies

Re: Help

Gourav,

Is your Dimension is what?

Meantime, Can i know what expression you are written over there?

- Anil

panipat1990
Contributor II

Re: Help

year is my dimension..

MVP
MVP

Re: Help

What you say same as in 2013... would it sum the count of ids for 2000 till 2012 or 2001 till 2012??? I think you need to provide more details as to what the final product needs to look like.

Doing this in the script works for you or do you need a front end option here?

Re: Help

Sunny,

1) Might be he want to achieve if we select 2013 Data he want to show like Starting Year - 2013 / 2012 (Depends on Calendar) ?

2) If data has Year with 2000 to 2016 ( If we select 2003 he want to show from 2000 to 2003 / 2002)

- Anil

manucamon
Valued Contributor III

Re: Help

Hi Gourav,

See attached.

Regards!!

Re: Help

Manuel,

In this scenario if Customer select 2001 i want to show 2000 & 2001 Data

Meantime, If Customer select the 2005 i want to show 2000, 2001, 2002, 2003, 2004, 2005 Data

Can i know what is the Expression to achieve this???

manucamon
Valued Contributor III

Re: Help

Hi Anil,

For not accum: sum({<Year = {'<=$(=Max(Year))'}>}EmpID)

For accum: RangeSum(if(Year =  vMaxYear, sum({<Year = {'=$(=Max(Year))'}>}EmpID)),sum({1<Year = p({1<Year={'<$(vMaxYear)'}>} Year)>}EmpID))

Regards!

Re: Help

Nice Explanation,

If i want to show when document is opened with Selection of 2006 Data Directly?

manucamon
Valued Contributor III

Re: Help

Hi Anil,

You need to create a trigger when document is open:

Document Properties -> Triggers -> Document Event Triggers -> OnOpen -> AddAction.

Add an action to Select In Field ->

     Field -> Year

     Search String -> 2016 (if it is manually), Year(Today()) (if you wanna it dynamic)

Regards!