topic Re: Ad-Hoc Report (Flexible Report) Query. in QlikView

Ad-Hoc Report (Flexible Report) Query.

MuraliPrasath — Wed, 25 Nov 2020 16:16:04 GMT

Hi QV Team,

I've a Ad-hoc report that works fine. Now I need to make one dimension has default selection.

How to achieve this?

Thanks,

Murali

Re: Ad-Hoc Report (Flexible Report) Query.

Anonymous — Mon, 03 Apr 2017 03:20:00 GMT

How about setting a trigger to set the default value in the Document properties on open??

Re: Ad-Hoc Report (Flexible Report) Query.

MuraliPrasath — Mon, 03 Apr 2017 03:25:23 GMT

Hi Shiva,

Do you have any examples? Please do share.

Thanks,

Murali

Re: Ad-Hoc Report (Flexible Report) Query.

Anonymous — Mon, 03 Apr 2017 03:49:54 GMT

PFA

Ctrl+Alt+D -> Triggers - > OnOpen -> Add actions - > Select in Field - > Dimension adn Value in text box.

Re: Ad-Hoc Report (Flexible Report) Query.

MuraliPrasath — Mon, 03 Apr 2017 04:31:04 GMT

Hi Shiva,

Here my attached Ad-hoc report. Now tell me how to make default dimension has Country?

Thanks in advance !

Re: Ad-Hoc Report (Flexible Report) Query.

ramasaisaksoft — Mon, 03 Apr 2017 05:08:51 GMT

Hi Murali,

i am unable to open ur application due to security restrictions.

I hope you gave all dimensions are conditional dimensions.(Enable conditional check box in Dimensions Tab) just

un check this option for Country Dimension as per your requirement..

FYI..please go through the below link also.

https://www.analyticsvidhya.com/blog/2014/01/customize-reporting-qlikview/

Re: Ad-Hoc Report (Flexible Report) Query.

Anonymous — Mon, 03 Apr 2017 05:19:10 GMT

Hi Srithar, May i know the reason why you are clearing all on opening the sheet??

Re: Ad-Hoc Report (Flexible Report) Query.

MuraliPrasath — Mon, 03 Apr 2017 05:29:53 GMT

Hi Shiva,

Please ignore that "All Clear on opening" and I'm looking for default selection field on my ad-hoc report dimension.

That is a example Ah-hoc report.

Thanks,

Murali

Re: Ad-Hoc Report (Flexible Report) Query.

Anonymous — Mon, 03 Apr 2017 05:54:44 GMT

Check Attached .qvw .

Ctrl+Alt+D -> Triggers - > OnOpen -> Add actions - > Select in Field - > Dimension adn Value in text box

Re: Ad-Hoc Report (Flexible Report) Query.

MuraliPrasath — Mon, 03 Apr 2017 06:13:50 GMT

Thank You Shiva. It worked successfully. You have a good day and keep Qliking !