6 Replies Latest reply: Jul 30, 2014 2:37 AM by Tobias Klett RSS

    Making Selections in Straight Table

    Matt Maino

      Hi, I'm wondering if it is possible to make individual selections on a field in a straight table. Currently if I click on any field value in a row it automatically adds the two dimension values associated to that row to the current selections, and not the field value that I clicked. I know that a regular table allows this, but I cant use that because I only want to show a specific set of data in the table. Thank you.

        • Re: Making Selections in Straight Table
          Tobias Klett

          Hi,
          go to chart > properties > presentation > mark drop down for the field you want to select.
          Afterwards you can use the small dropdown sign on the dimension to selct values.

           

          Note: QlikView selcts all dimensions of the chart if you click in the expressions, so you actually only need to klick into the dimensions to select only one dimension value..

           

          Hope this helps
          Tobias

            • Re: Making Selections in Straight Table
              Matt Maino

              I'm more interested in having the straight table behave like a basic table where you can click anything and have that become the current selection. Is this possible?

                • Re: Making Selections in Straight Table
                  Tobias Klett

                  yes, as i said.
                  just watch to click into dimension columns and not into expression columns. :-)

                    • Re: Making Selections in Straight Table
                      Matt Maino

                      I'm not exactly sure what you're saying. If I click an expression value I would like for that to show up in the current selections. Are you saying to add everything as as a dimension?

                        • Re: Making Selections in Straight Table
                          Tobias Klett

                          sorry, I was not clear enough.
                          Look at my Picture. It has a very simple straight table chart with two dimensions (Material, Date) and one Expression (Sales).
                          Selection_Dim_Expr.png
                          What I am saying is: Click within the Dim1 column and it will select the Material, click within the Dim2 column and it will select the Date; but click within the Exp1 column and it will select the Material of this line AND the Date of this line. Meaning if you click within Expressions it will always select all dimensions of this line but if you click in dimensions it will always only select within this dimension.
                          There is no way to select a value of the expression because it does not exist within the datafield but is the sum or count of it. If you want to select values you can put the values into the dimensions or use a tablebox which d doesn't have any expression.

                           

                          Hope this helps

                  • Re: Making Selections in Straight Table
                    Josh Abbott

                    Hello,

                     

                    I just tried one of my straight tables, and it only selected the dimension I clicked, instead of both dimensions in the table.  Could you upload an example?