topic Alternate State in QlikView

Alternate State

manoranjan_d — Mon, 31 Jul 2017 09:09:45 GMT

Hi all,

In my UI i have two filters and one straight table

These two filters are defined with state

Filter 1 (field name : week end ) as state 1

and filter 2 (field name : week end ) as state 2

in the straight all the expression as defined with the two state

example

exp1:

=Only({[State1]}base_details)

exp2:

=Only({[State2]}base_details)

so the user can make week wise compare

Now third filter needs to be added

example : description field as filter3

suppose if the user select the filter 3(description filed) the data in the straight table wont change as per the filter3 selection bcoz we have declared the exp as state1 and state2, now how to show the straight table data with slection of filter1,filter2 and filter 3.

Re: Alternate State

arvind_patil — Mon, 31 Jul 2017 09:14:44 GMT

HI Manoranjan,

yes it cant work because description field will be common for all if you use filter 3 as week day then it work . Other wise try to in separate table it will work .

Thanks,

Arvind Patil

Re: Alternate State

Kushal_Chawda — Mon, 31 Jul 2017 10:29:43 GMT

=Only({[State1] <Filter1 = $::Filter1, Filter2 =$::Filter2 > }base_details)

like wise you can do for other state

Update : As sunny highlighted, added '=' sign

Re: Alternate State

sunny_talwar — Mon, 31 Jul 2017 11:29:02 GMT

Don't you need an equal sign between Filter and $::Filter? Or does it work without equal also?

Re: Alternate State

Kushal_Chawda — Mon, 31 Jul 2017 11:32:49 GMT

Yes we need . that' s the typo