Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
manoranjan_d
Contributor II

Expression details

=Only({<[primary compare date]=[state2]::[primary compare date]>}amount


can any one explain this expression

15 Replies

Re: Expression details

This expression is going to show you the amount based on primary compare date selection in state2. Rest all selections will be from your inherited state.

manoranjan_d
Contributor II

Re: Expression details

Hi Sunny

so suppose if the any other list box  have inhertited state means then the value is also shown as per the selection?

pls correct if i wrong

Re: Expression details

Yes, for instance if you have Year list box in inherited state... your expression value will change based on this list box object

mangalsk
Contributor III

Re: Expression details

It will take [primary compare date] from state 2 only and [primary compare date] from inheritate state if you select then also it will not affect, rest all filters like year or region or country will be taken by inheritated fields or if any other alternate state you are selecting.

manoranjan_d
Contributor II

Re: Expression details

suppose if want to bring only the year list box and sate 2 in the expression means i have to achieve below expression?

=Only({state2<year=$::year>}amount)



Re: Expression details

This will respect all selections in state2, except year field. For year field it will look at the default state

manoranjan_d
Contributor II

Re: Expression details

Hi Sunny,

ok

if i want  particular filed selection with state means can i go with this exp:=Only({state2<year=$::year>}amount)

note: particular filed means year


if i want to all filed as per the selection with state means can i go with this exp:

=Only({<[primary compare date]=[state2]::[primary compare date]>}amount)

note: all filed means year,region and so on in the UI part

Re: Expression details

Not sure what you are trying to say???

manoranjan_d
Contributor II

Re: Expression details


as per discussion

=Only({<[primary compare date]=[state2]::[primary compare date]>}amount)


This expression is going to show you the amount based on primary compare date selection in state2. Rest all selections will be from your inherited state.



rest all selections as been discussed above,


suppose if want only particular filed in this expression means how to do this? example year field selection and with state 2