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: 
soniasweety
Master
Master

Multi select report

Hi all,

Sunny Talwar

I have a adhoc report  the application is working fine enough.

with the dimensions

Company

id

month

year

product

My requirement is :  1. whenever user selects the dim and measure combination with year and month  and one measure

in the result table  it show in order like  first year  and  then month  [ this should be every selection ]

2.  by default it  is asking to select one measure and one dimension   instead user want to  select  two dimensions and two measures

how can I do this?

thanks

Sony.

1 Solution

Accepted Solutions
vishsaggi
Champion III
Champion III

may be you want to add on activate sheet trigger like

Click Ctrl+Alt+S to open Sheet properties -> Triggers Tab -> Click on Activate sheet -> Actions -> Select in field like below:

Dim.PNG

Measure.PNG

View solution in original post

8 Replies
neelamsaroha157
Specialist II
Specialist II

For Req. 1 -  If you need Year and Month to always apear as 1st and 2nd dimension respectively then change the sequence on the dimension tab.

Req. 2 - You can select any number of dimensions and measure (it says 'atleast' one). If you want to change the message then it can be changed on the General tab -> error Message->

I am not sure if this is what you were looking for.

vishsaggi
Champion III
Champion III

Are you looking something like this? Check attached.

soniasweety
Master
Master
Author

thanks Raju,

1. sort order is working as expected    -  working fine  now

2.  this one  by default  table should show  any of two dimensions and measures should select  [ like how we set always one selected value like that user want two values to be selected]

this requirement -bcz user don't want to see empty table while opening the document that's why.

hope this is clear? 

soniasweety
Master
Master
Author

Hi  Bala Bhaskar   any idea on this?

vishsaggi
Champion III
Champion III

may be you want to add on activate sheet trigger like

Click Ctrl+Alt+S to open Sheet properties -> Triggers Tab -> Click on Activate sheet -> Actions -> Select in field like below:

Dim.PNG

Measure.PNG

soniasweety
Master
Master
Author

thanks I got it

manoj217
Creator III
Creator III

But if we are hiding the tabs in that case these triggers will not work so we have to go for actions in that case how can we perform this

manoj217
Creator III
Creator III

i am also having the req but triggers will not work in my app because we are using buttons to navigate sheets and tab row is hide