Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
manoranjan_d
Specialist
Specialist

Alternate State

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.

4 Replies
arvind_patil
Partner - Specialist III
Partner - Specialist III

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

Kushal_Chawda

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


like wise you can do for other state


Update : As sunny highlighted, added '=' sign

sunny_talwar

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

Kushal_Chawda

Yes we need . that' s the typo