Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
soniasweety
Valued Contributor III

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.

Tags (3)
1 Solution

Accepted Solutions
vishsaggi
Esteemed Contributor III

Re: Multi select report

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
Valued Contributor II

Re: Multi select report

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
Esteemed Contributor III

Re: Multi select report

Are you looking something like this? Check attached.

soniasweety
Valued Contributor III

Re: Multi select report

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
Valued Contributor III

Re: Multi select report

Hi  Bala Bhaskar   any idea on this?

vishsaggi
Esteemed Contributor III

Re: Multi select report

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

soniasweety
Valued Contributor III

Re: Multi select report

thanks I got it

manoj217
Contributor III

Re: Multi select report

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
Contributor III

Re: Multi select report

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