Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kartikaysingh
Contributor III
Contributor III

Need to get below filter values as default when user click on the tab.

Hi All,

Urgent help required.

I have a multi tab qlikview dashboard report and customer have asked to add couple of more tabs in the report.

His requirement is that when user clicks on the report tab one of the filter values should be selected automatically.

I know this can be achieved via the Trigger option in the Sheet properties, but my values are like below

If I put value as below

it will take '10,000-25,000' selection and given the resultant values in graphs. Bu the moment I concatenate

'10,000-25,000' & '25,000-50,000' it will select nothing.

Please let me know how I can concatenate it to select all the three values of the filter as in first figure. I think the problem is the concatenation between string and numbers i.e. - and numerals.

1 Solution

Accepted Solutions
Anil_Babu_Samineni

You have to use this?

='(' & '10,000-25,000' & '|' & '25,000-50,000' & ')'

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

7 Replies
Anil_Babu_Samineni

You have to use this?

='(' & '10,000-25,000' & '|' & '25,000-50,000' & ')'

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
jonathandienst
Partner - Champion III
Partner - Champion III

='("10,000-25,000"|"25,000-50,000")'

(those are double quotes around each value)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
jonathandienst
Partner - Champion III
Partner - Champion III

If there are no spaces, you can also use (no = sign and single quotes)

("10,000-25,000"|"25,000-50,000")

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
its_anandrjs

In Select in Field Event write only this string will work for you

("10,000-25,000"|"25,000-50,000"|"50,000-100,000")

See Attached

kartikaysingh
Contributor III
Contributor III
Author

Thanks,,

kartikaysingh
Contributor III
Contributor III
Author

Thanks it worked..

kartikaysingh
Contributor III
Contributor III
Author

thanks it worked...