https://community.qlik.com/t5/QlikView/How-to-write-different-expression-for-two-fields-in-a-cyclic/m-p/1544128#M744925 Are you utsikt correct spelling for GetCurrentField(GeoGroup) ? It's not GetCurrentFields(GeoGroup) .<BR /><BR />The pseudo expression below should work.<BR /><BR />If(GetCurrentField(GeoGroup) = 'Country',<BR />Sum(Countrymeasure1),<BR />Sum(Othermeasure)<BR />) Thu, 14 Feb 2019 09:17:14 GMT Vegar 2019-02-14T09:17:14Z https://community.qlik.com/t5/QlikView/How-to-write-different-expression-for-two-fields-in-a-cyclic/m-p/1544086#M744924 <P>Hi Guys,</P><P>I have to write two separate expression for two fields in a cyclic group. So, for example, I have a cyclic group called GeoGroup which has two fields i.e, Region and Country. Now I have to use it in a bar chart but i want to make small change in my main expression based on the field the user selects in the chart. So, if the user selects Region, Exp_1 should be executed and if he/she selects Country field then the Exp_2 should get executed.</P><P>I tried implementing this using GetCurrentFields(GeoGroup) function but it doesn't work for some reason.</P><P>Any suggestion or a tip would be great as I need to get this done quickly.</P><P>Thanks,</P><P>Pranav</P> Sat, 16 Nov 2024 21:24:47 GMT https://community.qlik.com/t5/QlikView/How-to-write-different-expression-for-two-fields-in-a-cyclic/m-p/1544086#M744924 pranaview 2024-11-16T21:24:47Z https://community.qlik.com/t5/QlikView/How-to-write-different-expression-for-two-fields-in-a-cyclic/m-p/1544128#M744925 Are you utsikt correct spelling for GetCurrentField(GeoGroup) ? It's not GetCurrentFields(GeoGroup) .<BR /><BR />The pseudo expression below should work.<BR /><BR />If(GetCurrentField(GeoGroup) = 'Country',<BR />Sum(Countrymeasure1),<BR />Sum(Othermeasure)<BR />) Thu, 14 Feb 2019 09:17:14 GMT https://community.qlik.com/t5/QlikView/How-to-write-different-expression-for-two-fields-in-a-cyclic/m-p/1544128#M744925 Vegar 2019-02-14T09:17:14Z