topic Adding (and Subtracting) Years in a Straight Chart in QlikView https://community.qlik.com/t5/QlikView/Adding-and-Subtracting-Years-in-a-Straight-Chart/m-p/87916#M767917 <HTML><HEAD></HEAD><BODY><P>Hi Experts.</P><P>I have a goo done for you today.</P><P>I have a planned straight chart and would like to show the following year planned information when the user is in the current year. </P><P>I have created a variable called vLookAhead: AddYears(YearStart(Year),1) where I would like to add it to the follwoing expression for the current years planned data:</P><P></P><P>=Count({$&lt;[Date Type]={'Dates'},Reference_Only={'No'}&gt;}[Sales])</P><P></P><P>All dates are coming into the Dashboard via a Date Bridge. I am also using a Master Calendar and in order for the Dashboard to pull the right date from corresponding file, I have to specify it i.e. [Date Type] = {'VPP Dates'}. </P><P></P><P>Can someone please help me with setting up the Set Analysis for this?</P><P></P><P>Ideally, the final table will look like the attached where 2018, 2017, and 2016 will be subsequent one row charts below the main 2019 chart.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT ZoeM 2020-11-25T16:16:04Z Adding (and Subtracting) Years in a Straight Chart https://community.qlik.com/t5/QlikView/Adding-and-Subtracting-Years-in-a-Straight-Chart/m-p/87916#M767917 <HTML><HEAD></HEAD><BODY><P>Hi Experts.</P><P>I have a goo done for you today.</P><P>I have a planned straight chart and would like to show the following year planned information when the user is in the current year. </P><P>I have created a variable called vLookAhead: AddYears(YearStart(Year),1) where I would like to add it to the follwoing expression for the current years planned data:</P><P></P><P>=Count({$&lt;[Date Type]={'Dates'},Reference_Only={'No'}&gt;}[Sales])</P><P></P><P>All dates are coming into the Dashboard via a Date Bridge. I am also using a Master Calendar and in order for the Dashboard to pull the right date from corresponding file, I have to specify it i.e. [Date Type] = {'VPP Dates'}. </P><P></P><P>Can someone please help me with setting up the Set Analysis for this?</P><P></P><P>Ideally, the final table will look like the attached where 2018, 2017, and 2016 will be subsequent one row charts below the main 2019 chart.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Adding-and-Subtracting-Years-in-a-Straight-Chart/m-p/87916#M767917 ZoeM 2020-11-25T16:16:04Z