topic Qliksense duplicate records to filter based on selection of column in adhoc report in App Development https://community.qlik.com/t5/App-Development/Qliksense-duplicate-records-to-filter-based-on-selection-of/m-p/1792333#M61995 <P>Dear All,</P><P>&nbsp;</P><P>Based on below scenario needs to filter data based on</P><P>input</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Vendor</TD><TD>PAN</TD><TD>Acc.Grp</TD><TD>GST</TD><TD>Concat Key</TD></TR><TR><TD>A</TD><TD>P1</TD><TD>AC1</TD><TD>G1</TD><TD>P1G1</TD></TR><TR><TD>C</TD><TD>P1</TD><TD>AC3</TD><TD>G1</TD><TD>P1G1</TD></TR><TR><TD>B</TD><TD>P2</TD><TD>AC2</TD><TD>G1</TD><TD>P2G1</TD></TR><TR><TD>D</TD><TD>P4</TD><TD>AC4</TD><TD>G4</TD><TD>P4G4</TD></TR></TBODY></TABLE><P>note concat to use in variaous output</P><P>&nbsp;when user select from left pane and PAN&amp;GST then ouput</P><P>this output require to be used in variable and concatkey&nbsp; as variable appear in qlikdashboard using key filter.</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Vendor</TD><TD>PAN</TD><TD>Acc.Grp</TD><TD>GST</TD><TD>Concat Key</TD></TR><TR><TD>A</TD><TD>P1</TD><TD>AC1</TD><TD>G1</TD><TD>P1G1</TD></TR><TR><TD>C</TD><TD>P1</TD><TD>AC3</TD><TD>G1</TD><TD>P1G1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Regards</P><P>abhi</P> Wed, 17 Mar 2021 19:14:31 GMT abhinayranjan11 2021-03-17T19:14:31Z Qliksense duplicate records to filter based on selection of column in adhoc report https://community.qlik.com/t5/App-Development/Qliksense-duplicate-records-to-filter-based-on-selection-of/m-p/1792333#M61995 <P>Dear All,</P><P>&nbsp;</P><P>Based on below scenario needs to filter data based on</P><P>input</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Vendor</TD><TD>PAN</TD><TD>Acc.Grp</TD><TD>GST</TD><TD>Concat Key</TD></TR><TR><TD>A</TD><TD>P1</TD><TD>AC1</TD><TD>G1</TD><TD>P1G1</TD></TR><TR><TD>C</TD><TD>P1</TD><TD>AC3</TD><TD>G1</TD><TD>P1G1</TD></TR><TR><TD>B</TD><TD>P2</TD><TD>AC2</TD><TD>G1</TD><TD>P2G1</TD></TR><TR><TD>D</TD><TD>P4</TD><TD>AC4</TD><TD>G4</TD><TD>P4G4</TD></TR></TBODY></TABLE><P>note concat to use in variaous output</P><P>&nbsp;when user select from left pane and PAN&amp;GST then ouput</P><P>this output require to be used in variable and concatkey&nbsp; as variable appear in qlikdashboard using key filter.</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Vendor</TD><TD>PAN</TD><TD>Acc.Grp</TD><TD>GST</TD><TD>Concat Key</TD></TR><TR><TD>A</TD><TD>P1</TD><TD>AC1</TD><TD>G1</TD><TD>P1G1</TD></TR><TR><TD>C</TD><TD>P1</TD><TD>AC3</TD><TD>G1</TD><TD>P1G1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Regards</P><P>abhi</P> Wed, 17 Mar 2021 19:14:31 GMT https://community.qlik.com/t5/App-Development/Qliksense-duplicate-records-to-filter-based-on-selection-of/m-p/1792333#M61995 abhinayranjan11 2021-03-17T19:14:31Z