topic Re: pivot table selection should activate straight table in QlikView

pivot table selection should activate straight table

Thu, 29 Nov 2012 19:33:00 GMT

I have one pivot table and a straight table.....I want to show pivot table always....and make straight table to pop up based on pivot table selections........Thnx.....

Re: pivot table selection should activate straight table

CELAMBARASAN — Thu, 29 Nov 2012 19:56:02 GMT

Can you tell briefly about your requirements?

Re: pivot table selection should activate straight table

Thu, 29 Nov 2012 20:30:49 GMT

I have pivot table in client level.....and when I select any client I have some expressions related to that client......so when they select that expression values I need a straight table to pop up with selected details.........

Please find my attchment.....

Re: pivot table selection should activate straight table

Thu, 29 Nov 2012 21:52:15 GMT

I got it from this link and its working fine But I am not clear how the below expression is evaluating......

= not

isnull(Only(Field name))

http://community.qlik.com/message/257070#257070

Re: pivot table selection should activate straight table

CELAMBARASAN — Thu, 29 Nov 2012 22:07:38 GMT

I didn't get what is your requirement.bit cofusing.

=not isnull(Only(FieldName)) will return true or false

Only(FieldName) will return value if only one possible(or selected) value in that field otherwise it will return null value.

Re: pivot table selection should activate straight table

Fri, 30 Nov 2012 16:05:20 GMT

Thanks..I am using 2 text objects with expressions

=only(Fieldname)

=Fieldname

Both text objects are displaying same result on selection.........So why should I go for Only again....Can you please give me difference....