topic Re: Help in QlikView

Help

panipat1990 — Mon, 26 Jan 2026 18:19:17 GMT

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

Re: Help

Anil_Babu_Samineni — Mon, 20 Jun 2016 17:00:42 GMT

Gourav,

Is your Dimension is what?

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

- Anil

Re: Help

panipat1990 — Mon, 20 Jun 2016 17:03:09 GMT

year is my dimension..

Re: Help

sunny_talwar — Mon, 20 Jun 2016 22:02:30 GMT

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

Anil_Babu_Samineni — Tue, 21 Jun 2016 07:43:13 GMT

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

Re: Help

Anonymous — Tue, 21 Jun 2016 09:27:43 GMT

Hi Gourav,

See attached.

Regards!!

Re: Help

Anil_Babu_Samineni — Tue, 21 Jun 2016 09:34:35 GMT

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

Re: Help

Anonymous — Tue, 21 Jun 2016 09:42:57 GMT

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

Anil_Babu_Samineni — Tue, 21 Jun 2016 11:13:24 GMT

Nice Explanation,

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

Re: Help

Anonymous — Tue, 21 Jun 2016 11:26:57 GMT

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!

Re: Help

panipat1990 — Tue, 21 Jun 2016 17:09:31 GMT

Hi Sunny,

Actuall i want to cumulative sum from 2000 to 2012 in half of 2013 bar.and half bar show employee id of 2013.....

Same as 2014 case..cumulative sum of 2000 to 2013 half bar show and half show employee id of 2014......

Same as 2015 case...cumulative sum of 2000 to 2014 half bar show and half show employee id of 2015......

Same as 2016 Case...cumulative sum of 2000 to 2015 half bar show and half show employee id of 2016......

Re: Help

panipat1990 — Tue, 21 Jun 2016 17:32:40 GMT

Hi Manuel,

If i i use Year(Today()), then iit is not working..but when i use 2016 it is working.

Re: Help

panipat1990 — Tue, 21 Jun 2016 18:40:47 GMT

Hi Sunny,

My Filter year 2013,2014,2015,2016.

Is this possible in qv or not.

Re: Help

sunny_talwar — Wed, 22 Jun 2016 04:34:20 GMT

This?

Re: Help

Anonymous — Wed, 22 Jun 2016 06:10:58 GMT

Put it on a variable.

Regards!

Re: Help

Anonymous — Wed, 22 Jun 2016 06:11:33 GMT

Hi Sunny,

See my response for this requirement.

Regards!!

Re: Help

panipat1990 — Tue, 12 Jul 2016 10:33:23 GMT

Hi Sunny,

I have a table without date field. i want to Incremental load on this table without date field.. when the change of region name.Like Jind to Zind and Bhiwani to Bhawni . One alert automatically come on mail. how is it possible.kindly help me for solving this issue...

Code Name Region

100 Paul Rohtak

101 Rahul Jind

102 Rohit Sonipat

103 Rekha Bhiwai

104 Himanshu Panipat

105 Durgesh Chandigarh

106 Anil Delhi

Re: Help

panipat1990 — Wed, 13 Jul 2016 08:59:39 GMT

is this possible

Re: Help

Anil_Babu_Samineni — Wed, 13 Jul 2016 09:09:08 GMT

Without Date Field you want to use Increment Load. You can use your Code Values for changing the Values. Then try

Might be useful

Incremental Load without Date field

Incremental Load without date feildFor DML you can refer this

Re: Help

panipat1990 — Wed, 13 Jul 2016 09:49:08 GMT

But when the change of region like Jind to Zind and Bhwani to Bhwani..Then a alert change the region come on mail..how is possible