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

[#1]

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

[ramoncova06]

how are us filtering the data for each month ?

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

[sinanozdemir]

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 ?

[#4]

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 · Accepted solution]

sorry I didn't read the full requirement,

check the attached example, it uses alternate states

[#6]

Perfect, that was it I needed!

Thank You!

[ramoncova06]

Glad it worked, please mark the thread as closed

thanks