topic Non Aggregable data in Pivot Table in QlikView

topic Non Aggregable data in Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Non-Aggregable-data-in-Pivot-Table/m-p/1548543#M440073 <P>Hello,</P><P>I have report to show few dimensions with values in Pivot Table</P><P>Note : No measures and the dimensions are represented as KPI values with data types as text, number, percentage etc</P><P>RawData:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Customer</TD><TD>Product</TD><TD>KPI1</TD><TD>KPI2</TD><TD>KPI3</TD><TD>KPI4</TD><TD>KPI5</TD><TD>KPI6</TD><TD>KPI7</TD><TD>KPI8</TD><TD>KPI9</TD><TD>KPI10</TD></TR><TR><TD>X1</TD><TD>A1</TD><TD>0.01</TD><TD>AA</TD><TD>1%</TD><TD>25</TD><TD>abc</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>X1</TD><TD>A2</TD><TD>0.02</TD><TD>BB</TD><TD>2%</TD><TD>30</TD><TD>aabg</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>X1</TD><TD>A3</TD><TD>0.01</TD><TD>CC</TD><TD>5%</TD><TD>45</TD><TD>hjk</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>X2</TD><TD>A1</TD><TD>0.03</TD><TD>DD</TD><TD> </TD><TD>65</TD><TD>ar</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>X3</TD><TD>A1</TD><TD>0.05</TD><TD>BB</TD><TD> </TD><TD>56.5</TD><TD>aabg</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>X3</TD><TD>A2</TD><TD>1.12</TD><TD>CC</TD><TD> </TD><TD>62</TD><TD>hjk</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>X3</TD><TD>A3</TD><TD>1.887</TD><TD>BB</TD><TD> </TD><TD>78.5</TD><TD>aabg</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>X3</TD><TD>A4</TD><TD>2.159</TD><TD>CC</TD><TD> </TD><TD>84</TD><TD>hjk</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>X5</TD><TD>A1</TD><TD>2.431</TD><TD>DD</TD><TD> </TD><TD>89.5</TD><TD>ar</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>X5</TD><TD>A3</TD><TD>2.975</TD><TD>BB</TD><TD> </TD><TD>100.5</TD><TD>aabg</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>X5</TD><TD>A4</TD><TD>3.247</TD><TD>CC</TD><TD> </TD><TD>106</TD><TD>hjk</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>X5</TD><TD>A5</TD><TD>3.519</TD><TD>DD</TD><TD> </TD><TD>111.5</TD><TD>hjk</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR></TBODY></TABLE><P> </P><P>Converted the raw data to KPI Names & Values using cross table for displaying in pivot table as </P><TABLE><TBODY><TR><TD>Customer</TD><TD>Product</TD><TD>KPI Name</TD><TD>KPI Value</TD></TR><TR><TD>X1</TD><TD>A1</TD><TD>KPI1</TD><TD>0.01</TD></TR><TR><TD>X1</TD><TD>A1</TD><TD>KPI2</TD><TD>AA</TD></TR><TR><TD>X1</TD><TD>A1</TD><TD>KPI3</TD><TD>1%</TD></TR><TR><TD>X1</TD><TD>A1</TD><TD>KPI4</TD><TD>25</TD></TR><TR><TD>X1</TD><TD>A1</TD><TD>KPI5</TD><TD>abc</TD></TR><TR><TD>X1</TD><TD>A2</TD><TD>KPI1</TD><TD>0.02</TD></TR><TR><TD>X1</TD><TD>A2</TD><TD>KPI2</TD><TD>BB</TD></TR><TR><TD>X1</TD><TD>A2</TD><TD>KPI3</TD><TD>2%</TD></TR><TR><TD>X1</TD><TD>A2</TD><TD>KPI4</TD><TD>30</TD></TR><TR><TD>X1</TD><TD>A2</TD><TD>KPI5</TD><TD>aabg</TD></TR><TR><TD>X1</TD><TD>A3</TD><TD>KPI1</TD><TD>0.01</TD></TR><TR><TD>X1</TD><TD>A3</TD><TD>KPI2</TD><TD>CC</TD></TR><TR><TD>X1</TD><TD>A3</TD><TD>KPI3</TD><TD>5%</TD></TR><TR><TD>X1</TD><TD>A3</TD><TD>KPI4</TD><TD>45</TD></TR><TR><TD>X1</TD><TD>A3</TD><TD>KPI5</TD><TD>hjk</TD></TR></TBODY></TABLE><P> </P><P>Expected output:</P><TABLE><TBODY><TR><TD> </TD><TD>A1</TD><TD>A2</TD><TD>A3</TD><TD>A4</TD></TR><TR><TD> </TD><TD>KPI1</TD><TD>KPI2</TD><TD>KPI3</TD><TD>KPI4</TD><TD>KPI5</TD><TD>KPI1</TD><TD>KPI2</TD><TD>KPI3</TD><TD>KPI4</TD><TD>KPI5</TD><TD>KPI1</TD><TD>KPI2</TD><TD>KPI3</TD><TD>KPI4</TD><TD>KPI5</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>X1</TD><TD>0.01</TD><TD>AA</TD><TD>1%</TD><TD>25</TD><TD>abc</TD><TD>0.02</TD><TD>BB</TD><TD>2%</TD><TD>30</TD><TD>aabg</TD><TD>0.01</TD><TD>CC</TD><TD>5%</TD><TD>45</TD><TD>hjk</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>X2</TD><TD>1.01</TD><TD>AA</TD><TD>9%</TD><TD>35</TD><TD>abc</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>x3</TD><TD>0.05</TD><TD>BB</TD><TD> </TD><TD>56.5</TD><TD>aabg</TD><TD>1.12</TD><TD>CC</TD><TD> </TD><TD>62</TD><TD>hjk</TD><TD>1.887</TD><TD>BB</TD><TD> </TD><TD>78.5</TD><TD>aabg</TD><TD>2.159</TD><TD>CC</TD><TD> </TD><TD>84</TD><TD>hjk</TD></TR></TBODY></TABLE><P> </P><P>The challenge is there is no measure used in expression as sum or count etc</P><P>This is an urgent requirement and looking for an early help. Thanks in advance.</P><P> </P> Sat, 16 Nov 2024 21:21:22 GMT dwhanand 2024-11-16T21:21:22Z Non Aggregable data in Pivot Table https://community.qlik.com/t5/QlikView/Non-Aggregable-data-in-Pivot-Table/m-p/1548543#M440073 <P>Hello,</P><P>I have report to show few dimensions with values in Pivot Table</P><P>Note : No measures and the dimensions are represented as KPI values with data types as text, number, percentage etc</P><P>RawData:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Customer</TD><TD>Product</TD><TD>KPI1</TD><TD>KPI2</TD><TD>KPI3</TD><TD>KPI4</TD><TD>KPI5</TD><TD>KPI6</TD><TD>KPI7</TD><TD>KPI8</TD><TD>KPI9</TD><TD>KPI10</TD></TR><TR><TD>X1</TD><TD>A1</TD><TD>0.01</TD><TD>AA</TD><TD>1%</TD><TD>25</TD><TD>abc</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>X1</TD><TD>A2</TD><TD>0.02</TD><TD>BB</TD><TD>2%</TD><TD>30</TD><TD>aabg</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>X1</TD><TD>A3</TD><TD>0.01</TD><TD>CC</TD><TD>5%</TD><TD>45</TD><TD>hjk</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>X2</TD><TD>A1</TD><TD>0.03</TD><TD>DD</TD><TD> </TD><TD>65</TD><TD>ar</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>X3</TD><TD>A1</TD><TD>0.05</TD><TD>BB</TD><TD> </TD><TD>56.5</TD><TD>aabg</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>X3</TD><TD>A2</TD><TD>1.12</TD><TD>CC</TD><TD> </TD><TD>62</TD><TD>hjk</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>X3</TD><TD>A3</TD><TD>1.887</TD><TD>BB</TD><TD> </TD><TD>78.5</TD><TD>aabg</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>X3</TD><TD>A4</TD><TD>2.159</TD><TD>CC</TD><TD> </TD><TD>84</TD><TD>hjk</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>X5</TD><TD>A1</TD><TD>2.431</TD><TD>DD</TD><TD> </TD><TD>89.5</TD><TD>ar</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>X5</TD><TD>A3</TD><TD>2.975</TD><TD>BB</TD><TD> </TD><TD>100.5</TD><TD>aabg</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>X5</TD><TD>A4</TD><TD>3.247</TD><TD>CC</TD><TD> </TD><TD>106</TD><TD>hjk</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>X5</TD><TD>A5</TD><TD>3.519</TD><TD>DD</TD><TD> </TD><TD>111.5</TD><TD>hjk</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR></TBODY></TABLE><P> </P><P>Converted the raw data to KPI Names & Values using cross table for displaying in pivot table as </P><TABLE><TBODY><TR><TD>Customer</TD><TD>Product</TD><TD>KPI Name</TD><TD>KPI Value</TD></TR><TR><TD>X1</TD><TD>A1</TD><TD>KPI1</TD><TD>0.01</TD></TR><TR><TD>X1</TD><TD>A1</TD><TD>KPI2</TD><TD>AA</TD></TR><TR><TD>X1</TD><TD>A1</TD><TD>KPI3</TD><TD>1%</TD></TR><TR><TD>X1</TD><TD>A1</TD><TD>KPI4</TD><TD>25</TD></TR><TR><TD>X1</TD><TD>A1</TD><TD>KPI5</TD><TD>abc</TD></TR><TR><TD>X1</TD><TD>A2</TD><TD>KPI1</TD><TD>0.02</TD></TR><TR><TD>X1</TD><TD>A2</TD><TD>KPI2</TD><TD>BB</TD></TR><TR><TD>X1</TD><TD>A2</TD><TD>KPI3</TD><TD>2%</TD></TR><TR><TD>X1</TD><TD>A2</TD><TD>KPI4</TD><TD>30</TD></TR><TR><TD>X1</TD><TD>A2</TD><TD>KPI5</TD><TD>aabg</TD></TR><TR><TD>X1</TD><TD>A3</TD><TD>KPI1</TD><TD>0.01</TD></TR><TR><TD>X1</TD><TD>A3</TD><TD>KPI2</TD><TD>CC</TD></TR><TR><TD>X1</TD><TD>A3</TD><TD>KPI3</TD><TD>5%</TD></TR><TR><TD>X1</TD><TD>A3</TD><TD>KPI4</TD><TD>45</TD></TR><TR><TD>X1</TD><TD>A3</TD><TD>KPI5</TD><TD>hjk</TD></TR></TBODY></TABLE><P> </P><P>Expected output:</P><TABLE><TBODY><TR><TD> </TD><TD>A1</TD><TD>A2</TD><TD>A3</TD><TD>A4</TD></TR><TR><TD> </TD><TD>KPI1</TD><TD>KPI2</TD><TD>KPI3</TD><TD>KPI4</TD><TD>KPI5</TD><TD>KPI1</TD><TD>KPI2</TD><TD>KPI3</TD><TD>KPI4</TD><TD>KPI5</TD><TD>KPI1</TD><TD>KPI2</TD><TD>KPI3</TD><TD>KPI4</TD><TD>KPI5</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>X1</TD><TD>0.01</TD><TD>AA</TD><TD>1%</TD><TD>25</TD><TD>abc</TD><TD>0.02</TD><TD>BB</TD><TD>2%</TD><TD>30</TD><TD>aabg</TD><TD>0.01</TD><TD>CC</TD><TD>5%</TD><TD>45</TD><TD>hjk</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>X2</TD><TD>1.01</TD><TD>AA</TD><TD>9%</TD><TD>35</TD><TD>abc</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>x3</TD><TD>0.05</TD><TD>BB</TD><TD> </TD><TD>56.5</TD><TD>aabg</TD><TD>1.12</TD><TD>CC</TD><TD> </TD><TD>62</TD><TD>hjk</TD><TD>1.887</TD><TD>BB</TD><TD> </TD><TD>78.5</TD><TD>aabg</TD><TD>2.159</TD><TD>CC</TD><TD> </TD><TD>84</TD><TD>hjk</TD></TR></TBODY></TABLE><P> </P><P>The challenge is there is no measure used in expression as sum or count etc</P><P>This is an urgent requirement and looking for an early help. Thanks in advance.</P><P> </P> Sat, 16 Nov 2024 21:21:22 GMT https://community.qlik.com/t5/QlikView/Non-Aggregable-data-in-Pivot-Table/m-p/1548543#M440073 dwhanand 2024-11-16T21:21:22Z Re: Non Aggregable data in Pivot Table https://community.qlik.com/t5/QlikView/Non-Aggregable-data-in-Pivot-Table/m-p/1548545#M440074 <TABLE><TBODY><TR><TD> </TD><TD>A1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>A2</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>A3</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>A4</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD>KPI1</TD><TD>KPI2</TD><TD>KPI3</TD><TD>KPI4</TD><TD>KPI5</TD><TD>KPI1</TD><TD>KPI2</TD><TD>KPI3</TD><TD>KPI4</TD><TD>KPI5</TD><TD>KPI1</TD><TD>KPI2</TD><TD>KPI3</TD><TD>KPI4</TD><TD>KPI5</TD><TD>KPI1</TD><TD>KPI2</TD><TD>KPI3</TD><TD>KPI4</TD><TD>KPI5</TD></TR><TR><TD>X1</TD><TD>0.01</TD><TD>AA</TD><TD>1%</TD><TD>25</TD><TD>abc</TD><TD>0.02</TD><TD>BB</TD><TD>2%</TD><TD>30</TD><TD>aabg</TD><TD>0.01</TD><TD>CC</TD><TD>5%</TD><TD>45</TD><TD>hjk</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>X2</TD><TD>1.01</TD><TD>AA</TD><TD>9%</TD><TD>35</TD><TD>abc</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>x3</TD><TD>0.05</TD><TD>BB</TD><TD> </TD><TD>56.5</TD><TD>aabg</TD><TD>1.12</TD><TD>CC</TD><TD> </TD><TD>62</TD><TD>hjk</TD><TD>1.887</TD><TD>BB</TD><TD> </TD><TD>78.5</TD><TD>aabg</TD><TD>2.159</TD><TD>CC</TD><TD> </TD><TD>84</TD><TD>hjk</TD></TR></TBODY></TABLE> Mon, 25 Feb 2019 07:56:02 GMT https://community.qlik.com/t5/QlikView/Non-Aggregable-data-in-Pivot-Table/m-p/1548545#M440074 dwhanand 2019-02-25T07:56:02Z Re: Non Aggregable data in Pivot Table https://community.qlik.com/t5/QlikView/Non-Aggregable-data-in-Pivot-Table/m-p/1548629#M440079 <P>in the expression in the pivot table try this Text([KPI Value])</P> Mon, 25 Feb 2019 10:44:43 GMT https://community.qlik.com/t5/QlikView/Non-Aggregable-data-in-Pivot-Table/m-p/1548629#M440079 volakakis 2019-02-25T10:44:43Z