Help

[panipat1990]

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

[panipat1990]

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

[panipat1990]

Hi Manuel,

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

[panipat1990]

Hi Sunny,

My Filter year 2013,2014,2015,2016.

Is this possible in qv or not.

[sunny_talwar]

This?

[Anonymous]

Put it on a variable.

Regards!

[Anonymous]

Hi Sunny,

See my response for this requirement.

Regards!!

[panipat1990]

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

[panipat1990]

is this possible

[Anil_Babu_Samineni]

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

[panipat1990]

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