Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

Expression details

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


can any one explain this expression

15 Replies

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.

Creator III
Creator III

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

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

Creator III
Creator III

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.

Creator III
Creator III

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)



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

Creator III
Creator III

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

Not sure what you are trying to say???

Creator III
Creator III


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