topic Re: Dynamic Filters in qlikview in QlikView

Dynamic Filters in qlikview

Sat, 03 Oct 2015 12:15:38 GMT

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 — Sat, 03 Oct 2015 22:40:09 GMT

Try these conditions may be:

For ActRevenue and BgtRevenue

=GetFieldSelections(Filter1) = 'Revenue'

For ActExpenses and BgtExpenses

=GetFieldSelections(Filter1) = 'Expenses'

Sun, 04 Oct 2015 08:21:40 GMT

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 — Mon, 05 Oct 2015 08:03:42 GMT

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