Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
Valued Contributor III

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

sorry I didn't read the full requirement,

check the attached example, it uses alternate states

6 Replies
ramoncova06
Valued Contributor III

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

how are us filtering the data for each month ?

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

sinanozdemir
Valued Contributor III

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

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

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

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
Valued Contributor III

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

sorry I didn't read the full requirement,

check the attached example, it uses alternate states

Not applicable

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

Perfect, that was it I needed!

Thank You!

ramoncova06
Valued Contributor III

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

Glad it worked, please mark the thread as closed

thanks

Community Browser