Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
CezarioAbrantes
Contributor III
Contributor III

Filter in a dimension

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

10 Replies
CezarioAbrantes
Contributor III
Contributor III
Author

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.