I have successfully loaded an Excel table with 3 dimensions:
I want to create the following two (2) reports:
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??
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??