topic Re: Expression details in QlikView

Expression details

manoranjan_d — Tue, 01 Aug 2017 11:54:05 GMT

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

can any one explain this expression

Re: Expression details

sunny_talwar — Tue, 01 Aug 2017 11:56:34 GMT

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.

Re: Expression details

manoranjan_d — Tue, 01 Aug 2017 12:02:11 GMT

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

sunny_talwar — Tue, 01 Aug 2017 12:03:24 GMT

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

Re: Expression details

mangalsk — Tue, 01 Aug 2017 12:05:41 GMT

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.

Re: Expression details

manoranjan_d — Tue, 01 Aug 2017 12:06:45 GMT

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

sunny_talwar — Tue, 01 Aug 2017 12:08:14 GMT

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

Re: Expression details

manoranjan_d — Tue, 01 Aug 2017 12:12:18 GMT

Hi Sunny,

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

sunny_talwar — Tue, 01 Aug 2017 12:16:33 GMT

Not sure what you are trying to say???

Re: Expression details

manoranjan_d — Tue, 01 Aug 2017 12:19:00 GMT

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

Re: Expression details

sunny_talwar — Tue, 01 Aug 2017 12:21:43 GMT

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

year field from state2 or year field from inherited state?

Re: Expression details

manoranjan_d — Tue, 01 Aug 2017 12:31:11 GMT

not from state2 its from inherited state

Re: Expression details

sunny_talwar — Tue, 01 Aug 2017 12:35:51 GMT

Then this looks good

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

Why don't you test these expressions in a sample dashboard... you seem to know what they are doing, but you are looking for confirmation? and what better way to confirm, then by testing it out?

Re: Expression details

manoranjan_d — Tue, 01 Aug 2017 12:37:29 GMT

yes

Re: Expression details

sunny_talwar — Tue, 01 Aug 2017 12:39:14 GMT

So we are all good now?

Re: Expression details

manoranjan_d — Tue, 01 Aug 2017 12:40:38 GMT

yes thanks sunny. little confused on both expression now its fine thanks for the explanation