topic What's the best way of adding a VAR Column in a Pivot, knowing there is a Month/Quarter in the Columns in App Development https://community.qlik.com/t5/App-Development/What-s-the-best-way-of-adding-a-VAR-Column-in-a-Pivot-knowing/m-p/2413257#M94841 <P>I need to add a variance column between 2023 and 2023, what's the best way of doing that</P> Wed, 31 Jan 2024 20:28:24 GMT giohb_ 2024-01-31T20:28:24Z What's the best way of adding a VAR Column in a Pivot, knowing there is a Month/Quarter in the Columns https://community.qlik.com/t5/App-Development/What-s-the-best-way-of-adding-a-VAR-Column-in-a-Pivot-knowing/m-p/2413257#M94841 <P>I need to add a variance column between 2023 and 2023, what's the best way of doing that</P> Wed, 31 Jan 2024 20:28:24 GMT https://community.qlik.com/t5/App-Development/What-s-the-best-way-of-adding-a-VAR-Column-in-a-Pivot-knowing/m-p/2413257#M94841 giohb_ 2024-01-31T20:28:24Z Re: What's the best way of adding a VAR Column in a Pivot, knowing there is a Month/Quarter in the Columns https://community.qlik.com/t5/App-Development/What-s-the-best-way-of-adding-a-VAR-Column-in-a-Pivot-knowing/m-p/2413270#M94845 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/205703">@giohb_</a>&nbsp;This is combination of Pick(Match()) with Island table can be done. Please share the sample file to test with.&nbsp;</P> Wed, 31 Jan 2024 21:26:17 GMT https://community.qlik.com/t5/App-Development/What-s-the-best-way-of-adding-a-VAR-Column-in-a-Pivot-knowing/m-p/2413270#M94845 Anil_Babu_Samineni 2024-01-31T21:26:17Z Re: What's the best way of adding a VAR Column in a Pivot, knowing there is a Month/Quarter in the Columns https://community.qlik.com/t5/App-Development/What-s-the-best-way-of-adding-a-VAR-Column-in-a-Pivot-knowing/m-p/2413278#M94847 <P>Hi, Thanks for your response. Kindly check attached</P> Wed, 31 Jan 2024 21:49:33 GMT https://community.qlik.com/t5/App-Development/What-s-the-best-way-of-adding-a-VAR-Column-in-a-Pivot-knowing/m-p/2413278#M94847 giohb_ 2024-01-31T21:49:33Z