Dynamic Filters in qlikview

[#1]

HI all,

This is the data in my excel looks like dis

if i select Bgt and Revenue from 2 filters

i have 2 get

if i select Bgt and Expenses from 2 filters   i have to get

For 1 filter i, getting the result

but i added another filter i.e., Filter1

i created a another variable in the script like

but in the properties of straight table

in expression tab: what i have to write

pls guide me

For 1 filter ,by using these conditions

=$(vSelection)

if($(vSelection)=0,1,0)

im getting the result,

For 2 nd filter what are the expressions

i.e., for the filter Expenses and Revenue?????????????????????????????

[sunny_talwar]

Try these conditions may be:

For ActRevenue and BgtRevenue

=GetFieldSelections(Filter1) = 'Revenue'

For ActExpenses and BgtExpenses

=GetFieldSelections(Filter1) = 'Expenses'

[#3]

for budget revenue expression:i want these two filters

=GetFieldSelections(Filter1) = 'Revenue'

=GetFieldSelections(Filter) = 'Bgt'

How to combine these two expressions in conditional expression

[shair_abbas]

Hi...
I think it might help.
Use both expression separately.and provide condition on both.