Ad-Hoc Report (Flexible Report) Query.

[MuraliPrasath]

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

[Anonymous]

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

[MuraliPrasath]

Hi Shiva,

Do you have any examples? Please do share.

Thanks,

Murali

[Anonymous]

PFA

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

[MuraliPrasath]

Hi Shiva,

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

Thanks in advance !

[ramasaisaksoft]

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/

[Anonymous]

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

[MuraliPrasath]

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

[Anonymous · Accepted solution]

Check Attached .qvw .

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

[MuraliPrasath]

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