https://community.qlik.com/t5/QlikView/Changing-the-value-in-Inline-Field/m-p/1640265#M594988 <P>Hi you can try adding Price Type field to inline table and have all for values, two of them for Net value in Price type and the other two with Gross value.</P><P>Selections in Price Type field will filter the measure values.</P> Mon, 28 Oct 2019 09:35:32 GMT rubenmarin 2019-10-28T09:35:32Z https://community.qlik.com/t5/QlikView/Changing-the-value-in-Inline-Field/m-p/1639759#M594987 <P>Hello All,</P><P>I have a scenario where inline field value has to be changed based on one field selection. Net to Gross and vice versa.</P><P>Load * inline [</P><P>Measure</P><P>Net_Sales</P><P>Net_Sales_PY</P><P>];</P><P>I tried using Replace(Measure,'Net',$(vPrice)) where vPrice gives Net or Gross based on price type selection.</P><P>But this gives 4 records two above values and two values with gross.</P><P>How best we can change the value dynamically?</P> Sat, 16 Nov 2024 19:48:46 GMT https://community.qlik.com/t5/QlikView/Changing-the-value-in-Inline-Field/m-p/1639759#M594987 sivarajs 2024-11-16T19:48:46Z https://community.qlik.com/t5/QlikView/Changing-the-value-in-Inline-Field/m-p/1640265#M594988 <P>Hi you can try adding Price Type field to inline table and have all for values, two of them for Net value in Price type and the other two with Gross value.</P><P>Selections in Price Type field will filter the measure values.</P> Mon, 28 Oct 2019 09:35:32 GMT https://community.qlik.com/t5/QlikView/Changing-the-value-in-Inline-Field/m-p/1640265#M594988 rubenmarin 2019-10-28T09:35:32Z