Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
MuraliPrasath
Creator III
Creator III

Ad-Hoc Report (Flexible Report) Query.

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

1 Solution

Accepted Solutions
laddu_927
Specialist
Specialist

Check Attached .qvw .

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

View solution in original post

9 Replies
laddu_927
Specialist
Specialist

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

MuraliPrasath
Creator III
Creator III
Author

Hi Shiva,

Do you have any examples? Please do share.

Thanks,

Murali

laddu_927
Specialist
Specialist

PFA

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

MuraliPrasath
Creator III
Creator III
Author

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/

laddu_927
Specialist
Specialist

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

MuraliPrasath
Creator III
Creator III
Author

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

laddu_927
Specialist
Specialist

Check Attached .qvw .

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

View solution in original post

MuraliPrasath
Creator III
Creator III
Author

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