Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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......
Hi Manuel,
If i i use Year(Today()), then iit is not working..but when i use 2016 it is working.
Hi Sunny,
My Filter year 2013,2014,2015,2016.
Is this possible in qv or not.
This?
Put it on a variable.
Regards!
Hi Sunny,
See my response for this requirement.
Regards!!
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
is this possible
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
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