topic Re: Custom Column(s) in QlikView https://community.qlik.com/t5/QlikView/Custom-Column-s/m-p/782539#M277130 <HTML><HEAD></HEAD><BODY><P>Finally achieved. Created all custom dimensions and only one conditinal expression.</P><P></P><P>Thanks for your time</P></BODY></HTML> Tue, 13 Jan 2015 18:39:56 GMT Anonymous 2015-01-13T18:39:56Z Custom Column(s) https://community.qlik.com/t5/QlikView/Custom-Column-s/m-p/782538#M277129 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>Below is Pivot table requirement</P><P><IMG alt="Capture.PNG" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/75238_Capture.PNG" style="height: auto;" /></P><P>Here GTB, AWM and CBS are Dimension, when 3Q14, 4Q14 ...4Q15 are expressions.</P><P>valuelist('Actual', 'FRB B') created</P><P>Normally what happen all six expression (3Q14, 4Q14 ...4Q15) pop up for Actual and FRB B. I want exactly as above.</P><P></P><P>Under 3Q14 expression I applied condition if(valuelist('Actual', 'FRB B') = 'Actual', 0,1) still not work</P><P>How do I create custom column as Expression.</P><P></P><P>Thanking you</P><P><BR /> </P></BODY></HTML> Tue, 13 Jan 2015 17:49:03 GMT https://community.qlik.com/t5/QlikView/Custom-Column-s/m-p/782538#M277129 Anonymous 2015-01-13T17:49:03Z Re: Custom Column(s) https://community.qlik.com/t5/QlikView/Custom-Column-s/m-p/782539#M277130 <HTML><HEAD></HEAD><BODY><P>Finally achieved. Created all custom dimensions and only one conditinal expression.</P><P></P><P>Thanks for your time</P></BODY></HTML> Tue, 13 Jan 2015 18:39:56 GMT https://community.qlik.com/t5/QlikView/Custom-Column-s/m-p/782539#M277130 Anonymous 2015-01-13T18:39:56Z