Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
panipat1990
Creator II
Creator 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
Anil_Babu_Samineni

Gourav,

Is your Dimension is what?

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

- Anil

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
panipat1990
Creator II
Creator II
Author

year is my dimension..

sunny_talwar

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?

Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anonymous
Not applicable

Hi Gourav,

See attached.

Regards!!

Anil_Babu_Samineni

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???

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anonymous
Not applicable

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!

Anil_Babu_Samineni

Nice Explanation,

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anonymous
Not applicable

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!