https://community.qlik.com/t5/QlikView/Generate-Quarter-with-extra-values/m-p/1661943#M595263 <P>&nbsp;got an answer to this. Initially left join was not working as the former quarter values had trailing spaces.</P> Thu, 02 Jan 2020 08:10:48 GMT sujit_nath 2020-01-02T08:10:48Z https://community.qlik.com/t5/QlikView/Generate-Quarter-with-extra-values/m-p/1661939#M595262 <P>&nbsp;have a column Quarter containing values Q1,Q2,Q3 and Q4.</P><P>I want to generate a column TempQuarter in script such that the values are connected as -</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Quarter</TD><TD>TempQuarter</TD></TR><TR><TD>Q1</TD><TD>Q1</TD></TR><TR><TD>Q1</TD><TD>Q1 Actual</TD></TR><TR><TD>Q1</TD><TD>Q1 Plan</TD></TR><TR><TD>Q2</TD><TD>Q2</TD></TR><TR><TD>Q2</TD><TD>Q2 Actual</TD></TR><TR><TD>Q2</TD><TD>Q2 Plan</TD></TR><TR><TD>Q3</TD><TD>Q3</TD></TR><TR><TD>Q3</TD><TD>Q3 Actual</TD></TR><TR><TD>-------- and so on till Q4</TD><TD>-------- and so on till Q4</TD></TR></TBODY></TABLE> Sat, 16 Nov 2024 01:36:31 GMT https://community.qlik.com/t5/QlikView/Generate-Quarter-with-extra-values/m-p/1661939#M595262 sujit_nath 2024-11-16T01:36:31Z https://community.qlik.com/t5/QlikView/Generate-Quarter-with-extra-values/m-p/1661943#M595263 <P>&nbsp;got an answer to this. Initially left join was not working as the former quarter values had trailing spaces.</P> Thu, 02 Jan 2020 08:10:48 GMT https://community.qlik.com/t5/QlikView/Generate-Quarter-with-extra-values/m-p/1661943#M595263 sujit_nath 2020-01-02T08:10:48Z