Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi. Could you help me to apply a filter in a dimension? Is it possible? I'm a beginner in Qlik and programming, since I am administrator and not direct-related to "IT world".
I have a dimension called "Monthly Analysis" in the basis, where I classify the data of the months as "Current Month", "Previous Month", "Last Year" and "N/A".
I am creating a table to compare the data of the "Current Month" with "Previous Month", but I did not want to set a filter in every measure, since there are many measures in this table. I wanted to use a filter in the dimension. I thought about something like this, but it's not working. It appers the error "Invalid dimension":
={< [Monthly Analysis] = {'Current Month','Previous Month'} >}
I also tried to use another dimension to set this filter, but it didn't work as well:
=({< [Monthly Analysis] = {'Current Month','Previous Month'} >} [Year-Month])
Thanks
Cezário Abrantes
In fact, I have 1 dimension (Artigo), 2 columns ("Ano-Mês MoM" and "Valores") and 7 measures. Take a look at the pictures, please. I'm sorry cuz it is in Portuguese.