Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanty4u
MVP
MVP

RE:Dimension only.

Hi all,

I have one issue with stright table.

i ave applied trigger on that. but  when i select any one value in that table it is reflecting to next sheet.

but my req is ...wen i select dimension  it should  go to perticular sheet.  other than any selection it should behave lik  table only.?

how can i achieve this.

PFA  

Thanks in advance.

1 Solution

Accepted Solutions
sasikanth
Master
Master

HI,

You can disable expression selections

select the representation as link for all expressions

please see the attachment

View solution in original post

23 Replies
avinashelite

Try with the alternate state .. that will help you to keep the selection to certain objects or pages

Chanty4u
MVP
MVP
Author

tried dat also but its nt givng the exct for dimensions?

vikasmahajan

PFA sample application

HTH

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
vikasmahajan

Month dimension is used with alternate states.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
Chanty4u
MVP
MVP
Author

thnx vikas,

but my senario is diffrnt.

In my table i shud use trigger to  redirect to one perticular sheet  and  any other selections done in that table  it shud nt allow to select . it shud acts as a normal table?

PradeepReddy
Specialist II
Specialist II

I hope it is not possible,  the reason is

When you select expression column, measure will be calculated based on the dimension (internally dimension will be selected). consequently your trigger is working..


a small workaround to overcome this situation, change all the expressions to calculated dimensions.

see the attachment, it might be helpful..

Edit: attached the file.

Chanty4u
MVP
MVP
Author

thnq pradeep...but  in myy application  wen i use calucluated dimensions  it is shwng  as error...?

PradeepReddy
Specialist II
Specialist II

you have to do aggr() based on all listed dimensions in the table..

Chanty4u
MVP
MVP
Author

but wen use for my expressions its nt wrkng   i hve 8 expressions in my table