0 Replies Latest reply: Jul 30, 2014 7:20 AM by Theofanis Hatzis RSS

    Supress repeats of labels on table

      I have successfully loaded an Excel table with 3 dimensions:

           1. Category

           2. Code

           3. Data

       

      Screenshot_1.jpg

      I want to create the following two (2) reports:

      Report 1:

      Screenshot_2.jpg

           In this report as you can see the data of the first column (Category) have suppressed the repeats and there is no option on the      properties of the table I have created on my Qlik Sense Desktop application. How can I supress the repeats of the first column??

       

      Report 2:

      Screenshot_3.jpg

           In this report I want to create a table with only the data of the first category. I have already created a text box to show the category [A] but how can I export and show the data only from this category?? Is there any specific function for this like an sql statement??

       

      Yours sincerely