topic Re: Need to get below filter values as default when user click on the tab. in QlikView

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

kartikaysingh — Mon, 25 Sep 2017 13:49:19 GMT

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.

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

Anil_Babu_Samineni — Tue, 26 Sep 2017 03:44:32 GMT

You have to use this?

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

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

jonathandienst — Tue, 26 Sep 2017 06:02:04 GMT

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

(those are double quotes around each value)

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

jonathandienst — Tue, 26 Sep 2017 06:17:39 GMT

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

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

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

its_anandrjs — Tue, 26 Sep 2017 06:51:10 GMT

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

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

kartikaysingh — Tue, 26 Sep 2017 09:17:52 GMT

Thanks,,

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

kartikaysingh — Tue, 26 Sep 2017 09:22:23 GMT

Thanks it worked..

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

kartikaysingh — Tue, 26 Sep 2017 09:23:00 GMT

thanks it worked...