topic Re: Column level data reduction in QlikView https://community.qlik.com/t5/QlikView/Column-level-data-reduction/m-p/863162#M1258158 <HTML><HEAD></HEAD><BODY><P>I saw the above link....I'm not getting &lt;ANY&gt; option...I'm new to Qlikview...please give me an example...</P></BODY></HTML> Sun, 19 Apr 2015 10:54:51 GMT 2015-04-19T10:54:51Z Column level data reduction https://community.qlik.com/t5/QlikView/Column-level-data-reduction/m-p/863160#M1258154 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333330154419px;">Hi,<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">I am new to qlikview,I have the below requirement.....using section access I have to filter the column level data.</SPAN></P><P style="font-size: 13.3333330154419px;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">below is the source table.<BR /></SPAN></P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">F1&nbsp;&nbsp; F2&nbsp; F3 F4&nbsp; </P><P style="font-size: 13.3333330154419px;">A1&nbsp; B1 C1&nbsp; D1&nbsp;&nbsp; </P><P style="font-size: 13.3333330154419px;">A2&nbsp; B2&nbsp; C2&nbsp; D2</P><P style="font-size: 13.3333330154419px;">A3&nbsp; B3&nbsp; C3&nbsp; D3</P><P style="font-size: 13.3333330154419px;">A4&nbsp; B4&nbsp; C4&nbsp; D4</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">after using the section access.I need data below format</P><P style="font-size: 13.3333330154419px;"></P><TABLE border="0" cellpadding="0" cellspacing="0" style="margin-left: 70.85pt; font-size: 13.3333330154419px; font-family: 'Times New Roman';" width="256"><TBODY><TR><TD nowrap="nowrap" style="border: 1pt solid windowtext; padding: 0 5.4pt;" valign="bottom" width="64"><P></P></TD><TD nowrap="nowrap" style="border-top-color: windowtext; border-right-color: windowtext; border-bottom-color: windowtext; padding: 0 5.4pt; border-style: solid solid solid none; border-top-width: 1pt; border-right-width: 1pt; border-bottom-width: 1pt;" valign="bottom" width="64"><P style="font-size: 11pt; font-family: Calibri, sans-serif;"><SPAN style="color: black;"> Fld for access</SPAN></P></TD><TD nowrap="nowrap" style="border-top-color: windowtext; border-right-color: windowtext; border-bottom-color: windowtext; padding: 0 5.4pt; border-style: solid solid solid none; border-top-width: 1pt; border-right-width: 1pt; border-bottom-width: 1pt;" valign="bottom" width="64"><P style="font-size: 11pt; font-family: Calibri, sans-serif;"><SPAN style="color: black;">Value from</SPAN></P></TD><TD nowrap="nowrap" style="border-top-color: windowtext; border-right-color: windowtext; border-bottom-color: windowtext; padding: 0 5.4pt; border-style: solid solid solid none; border-top-width: 1pt; border-right-width: 1pt; border-bottom-width: 1pt;" valign="bottom" width="64"><P style="font-size: 11pt; font-family: Calibri, sans-serif;"><SPAN style="color: black;">Value to</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid;" valign="bottom" width="64"><P style="font-size: 11pt; font-family: Calibri, sans-serif;"><STRONG style="color: black;">USR1</STRONG></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid none;" valign="bottom" width="64"><P style="font-size: 11pt; font-family: Calibri, sans-serif;"><STRONG style="color: black;">F1</STRONG></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid none;" valign="bottom" width="64"><P style="font-size: 11pt; font-family: Calibri, sans-serif;"><STRONG style="color: black;">A3</STRONG></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid none;" valign="bottom" width="64"><P style="font-size: 11pt; font-family: Calibri, sans-serif;"><STRONG style="color: black;">A5</STRONG></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid;" valign="bottom" width="64"><P style="font-size: 11pt; font-family: Calibri, sans-serif;"><STRONG style="color: black;">USR2</STRONG></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid none;" valign="bottom" width="64"><P style="font-size: 11pt; font-family: Calibri, sans-serif;"><SPAN style="color: black;">F2</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid none;" valign="bottom" width="64"><P style="font-size: 11pt; font-family: Calibri, sans-serif;"><SPAN style="color: black;">B1</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid none;" valign="bottom" width="64"><P style="font-size: 11pt; font-family: Calibri, sans-serif;"><SPAN style="color: black;">B5</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid;" valign="bottom" width="64"><P style="font-size: 11pt; font-family: Calibri, sans-serif;"><STRONG style="color: black;">USR3</STRONG></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid none;" valign="bottom" width="64"><P style="font-size: 11pt; font-family: Calibri, sans-serif;"><SPAN style="color: black;">F1</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid none;" valign="bottom" width="64"><P style="font-size: 11pt; font-family: Calibri, sans-serif;"><SPAN style="color: black;">A3</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid none;" valign="bottom" width="64"><P></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid;" valign="bottom" width="64"><P></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid none;" valign="bottom" width="64"><P style="font-size: 11pt; font-family: Calibri, sans-serif;"><SPAN style="color: black;">F2</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid none;" valign="bottom" width="64"><P style="font-size: 11pt; font-family: Calibri, sans-serif;"><SPAN style="color: black;">B3</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid none;" valign="bottom" width="64"><P></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid;" valign="bottom" width="64"><P style="font-size: 11pt; font-family: Calibri, sans-serif;"><STRONG style="color: black;">USR4</STRONG></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid none;" valign="bottom" width="64"><P style="font-size: 11pt; font-family: Calibri, sans-serif;"><SPAN style="color: black;">F1</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid none;" valign="bottom" width="64"><P style="font-size: 11pt; font-family: Calibri, sans-serif;"><SPAN style="color: black;">ALL</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid none;" valign="bottom" width="64"><P></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid;" valign="bottom" width="64"><P></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid none;" valign="bottom" width="64"><P style="font-size: 11pt; font-family: Calibri, sans-serif;"><SPAN style="color: black;">F2</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid none;" valign="bottom" width="64"><P style="font-size: 11pt; font-family: Calibri, sans-serif;"><SPAN style="color: black;">B1</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid none;" valign="bottom" width="64"><P style="font-size: 11pt; font-family: Calibri, sans-serif;"><SPAN style="color: black;">B10</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid;" valign="bottom" width="64"><P></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid none;" valign="bottom" width="64"><P style="font-size: 11pt; font-family: Calibri, sans-serif;"><SPAN style="color: black;">F3</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid none;" valign="bottom" width="64"><P style="font-size: 11pt; font-family: Calibri, sans-serif;"><SPAN style="color: black;">C3</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid none;" valign="bottom" width="64"><P style="font-size: 11pt; font-family: Calibri, sans-serif;"><SPAN style="color: black;">C7</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid;" valign="bottom" width="64"><P></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid none;" valign="bottom" width="64"><P style="font-size: 11pt; font-family: Calibri, sans-serif;"><SPAN style="color: black;">F4</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid none;" valign="bottom" width="64"><P style="font-size: 11pt; font-family: Calibri, sans-serif;"><SPAN style="color: black;">D5</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid none;" valign="bottom" width="64"><P style="font-size: 11pt; font-family: Calibri, sans-serif;"><SPAN style="color: black;">D7</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid;" valign="bottom" width="64"><P></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid none;" valign="bottom" width="64"><P style="font-size: 11pt; font-family: Calibri, sans-serif;"><SPAN style="color: black;">F5</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid none;" valign="bottom" width="64"><P style="font-size: 11pt; font-family: Calibri, sans-serif;"><SPAN style="color: black;">All</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt; border-style: none solid solid none;" valign="bottom" width="64"><P></P></TD></TR></TBODY></TABLE><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">please do the needful..its very urgent requirement.</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Column-level-data-reduction/m-p/863160#M1258154 2026-01-26T18:19:17Z Re: Column level data reduction https://community.qlik.com/t5/QlikView/Column-level-data-reduction/m-p/863161#M1258156 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-blogpost/2775">Basics for complex authorization</A></P></BODY></HTML> Sun, 19 Apr 2015 10:49:13 GMT https://community.qlik.com/t5/QlikView/Column-level-data-reduction/m-p/863161#M1258156 maxgro 2015-04-19T10:49:13Z Re: Column level data reduction https://community.qlik.com/t5/QlikView/Column-level-data-reduction/m-p/863162#M1258158 <HTML><HEAD></HEAD><BODY><P>I saw the above link....I'm not getting &lt;ANY&gt; option...I'm new to Qlikview...please give me an example...</P></BODY></HTML> Sun, 19 Apr 2015 10:54:51 GMT https://community.qlik.com/t5/QlikView/Column-level-data-reduction/m-p/863162#M1258158 2015-04-19T10:54:51Z Re: Column level data reduction https://community.qlik.com/t5/QlikView/Column-level-data-reduction/m-p/863163#M1258161 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Take a look at the attached file. If you look toward the bottom of the document it will show what you are trying to do.</P><P></P><P>Bill</P></BODY></HTML> Mon, 20 Apr 2015 12:50:23 GMT https://community.qlik.com/t5/QlikView/Column-level-data-reduction/m-p/863163#M1258161 Bill_Britt 2015-04-20T12:50:23Z