Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to fix the value of a filter on a table while using global filters in QlikView?

Hy, guys.

I need a big help.

I created three pivot tables in the same tab, one for the current month (June), another for the month - 1 (May) and the last M - 2 (April).

For each table, need a unique date filter in which, for tohe month Current Table, the filter is from 01/06 to today, for the month - 1 is from  01/05 to 31/05...

Ultil then everything ok.

The problem occurs when I need to apply global filtersto all these tables, that is, when I select the filter client, it should be applied in three tables and, when I aplly rhe filter of the month, it be applied only in the table related to it.

Has anyone done this before?

Thank you very much.

Meirieli.

Mensagem editada por: Meirieli Ribeiro

1 Solution

Accepted Solutions
ramoncova06
Partner - Specialist III
Partner - Specialist III

sorry I didn't read the full requirement,

check the attached example, it uses alternate states

View solution in original post

6 Replies
ramoncova06
Partner - Specialist III
Partner - Specialist III

how are us filtering the data for each month ?

are you doing a set analysis for it or a calculated dimension?

sinanozdemir
Specialist III
Specialist III

Hi Meirieli,

Have you tried implementing alternate states?

That could be what you are looking for?

Here is a link to give you an idea

what is alternate states in Qlikview ?

Not applicable
Author

Hi, Ramon.

yes, it is this. I applied one filter on the script to define how month I want.

I,m used calculated dimension.

Thanks.

ramoncova06
Partner - Specialist III
Partner - Specialist III

sorry I didn't read the full requirement,

check the attached example, it uses alternate states

Not applicable
Author

Perfect, that was it I needed!

Thank You!

ramoncova06
Partner - Specialist III
Partner - Specialist III

Glad it worked, please mark the thread as closed

thanks