topic Re: Hii in QlikView https://community.qlik.com/t5/QlikView/Hii/m-p/803748#M1023124 <HTML><HEAD></HEAD><BODY><P>Okay Bhavana ..Tanq fr Sugg..i wil try</P></BODY></HTML> Mon, 16 Mar 2015 02:35:28 GMT 2015-03-16T02:35:28Z Hii https://community.qlik.com/t5/QlikView/Hii/m-p/803745#M1023119 <HTML><HEAD></HEAD><BODY><P> hi all ,</P><P>i am hvng data as</P><P>quarter</P><P>Q1</P><P>Q2</P><P>Q3</P><P>Q4</P><P>,year</P><P>2009</P><P>2010</P><P>2011</P><P>2012</P><P>,month,</P><P></P><P>jan</P><P>.</P><P>.</P><P>.</P><P>.dec</P><P></P><P>so the result vil b lik dis..</P><P></P><P>i wan year field as 2009Q1</P><P>2009Q2</P><P>2009Q3</P><P>2009Q4</P><P> like so on...upto 2012</P><P>means evry year i vil get wit in qurters</P><P></P><P>Please help me...</P></BODY></HTML> Sat, 14 Mar 2015 19:19:11 GMT https://community.qlik.com/t5/QlikView/Hii/m-p/803745#M1023119 2015-03-14T19:19:11Z Re: Hii https://community.qlik.com/t5/QlikView/Hii/m-p/803746#M1023120 <HTML><HEAD></HEAD><BODY><P>sorry try like this</P><P>Year &amp; Quarter as YearQuarter</P></BODY></HTML> Sun, 15 Mar 2015 08:29:29 GMT https://community.qlik.com/t5/QlikView/Hii/m-p/803746#M1023120 arulsettu 2015-03-15T08:29:29Z Re: Hii https://community.qlik.com/t5/QlikView/Hii/m-p/803747#M1023123 <HTML><HEAD></HEAD><BODY><P>you can concatenate your fields like this</P><P>Load *,</P><P>Year&amp;Quarter as YearQtr;</P><P>load * inline [</P><P>Year,Quarter,Month</P><P>2011,Q1,Feb</P><P>2012,Q3,Aug</P><P>2009,Q2,Jun</P><P>];</P></BODY></HTML> Sun, 15 Mar 2015 08:41:03 GMT https://community.qlik.com/t5/QlikView/Hii/m-p/803747#M1023123 2015-03-15T08:41:03Z Re: Hii https://community.qlik.com/t5/QlikView/Hii/m-p/803748#M1023124 <HTML><HEAD></HEAD><BODY><P>Okay Bhavana ..Tanq fr Sugg..i wil try</P></BODY></HTML> Mon, 16 Mar 2015 02:35:28 GMT https://community.qlik.com/t5/QlikView/Hii/m-p/803748#M1023124 2015-03-16T02:35:28Z Re: Hii https://community.qlik.com/t5/QlikView/Hii/m-p/803749#M1023125 <HTML><HEAD></HEAD><BODY><P>hI FIND BELOW SCREEN SHORT..</P><P></P><P>Hvng am hvng 2year data</P><P>if i select Q1 of 2010 display 2009 Q4</P><P>2010</P><P>Q1---&gt;Q2</P><P>Q2----&gt;Q3</P><P>Q3----&gt;Q4</P><P>Q4----&gt;Q1&nbsp;&nbsp; if Q4 select dispay previous year Q1 Data so Plase Find</P><P></P><P><IMG alt="" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/80778_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Mon, 16 Mar 2015 03:01:50 GMT https://community.qlik.com/t5/QlikView/Hii/m-p/803749#M1023125 2015-03-16T03:01:50Z Re: Hii https://community.qlik.com/t5/QlikView/Hii/m-p/803750#M1023128 <HTML><HEAD></HEAD><BODY><P>Can you please clarify your pbm statement clearly and send me your .qvw file as well.</P><P></P><P>Thanks</P><P>Lathaa</P></BODY></HTML> Mon, 16 Mar 2015 03:33:15 GMT https://community.qlik.com/t5/QlikView/Hii/m-p/803750#M1023128 2015-03-16T03:33:15Z Re: Hii https://community.qlik.com/t5/QlikView/Hii/m-p/803751#M1023129 <HTML><HEAD></HEAD><BODY><P>Please clarify your problem properly.</P></BODY></HTML> Mon, 16 Mar 2015 04:36:50 GMT https://community.qlik.com/t5/QlikView/Hii/m-p/803751#M1023129 senpradip007 2015-03-16T04:36:50Z Re: Hii https://community.qlik.com/t5/QlikView/Hii/m-p/803752#M1023130 <HTML><HEAD></HEAD><BODY><P>hi,,</P><P></P><P>In year 2009 four quaters Q1 to Q4</P><P>In year 2010 four quatersQ1 to Q4</P><P></P><P>if i select q1 in 2010 it wil disply 2009 q4 details lik so on...</P><P></P><P>means if v select q3 v vil disply q2 .....</P></BODY></HTML> Mon, 16 Mar 2015 05:35:08 GMT https://community.qlik.com/t5/QlikView/Hii/m-p/803752#M1023130 2015-03-16T05:35:08Z Re: Hii https://community.qlik.com/t5/QlikView/Hii/m-p/803753#M1023131 <HTML><HEAD></HEAD><BODY><P>Its clear that if Q1 of 2010 selected it will display data of Q4 of 2009. Its fine. Now what do you want if Q3 of 2010 is selected? Please clarify.</P></BODY></HTML> Mon, 16 Mar 2015 05:58:27 GMT https://community.qlik.com/t5/QlikView/Hii/m-p/803753#M1023131 senpradip007 2015-03-16T05:58:27Z Re: Hii https://community.qlik.com/t5/QlikView/Hii/m-p/803754#M1023132 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>see this qvw.It is correct answer.</P></BODY></HTML> Mon, 16 Mar 2015 06:34:08 GMT https://community.qlik.com/t5/QlikView/Hii/m-p/803754#M1023132 2015-03-16T06:34:08Z Re: Hii https://community.qlik.com/t5/QlikView/Hii/m-p/803755#M1023133 <HTML><HEAD></HEAD><BODY><P>hi</P><P>if v selece q3 of 2010 v vil get q2 of 2010 like so on...</P></BODY></HTML> Mon, 16 Mar 2015 07:16:23 GMT https://community.qlik.com/t5/QlikView/Hii/m-p/803755#M1023133 2015-03-16T07:16:23Z