Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
MuraliPrasath
Creator III
Creator III

Button Query on Ad-hoc report dimension limitaions?

Hi QV Team,

I've attached QVW example.

I've to limit the dimensions in Ad-hoc reports based on button selections.

In Attached Example, If I select Year then Year dimension should be listed, if I select Month then Year and week should not be listed.

On Button Selection  Year=1, Month=0, Week=0

                               Month=1, Year=0, Week=0

                               Week=1,Year=0, Month=0

1 Solution

Accepted Solutions
ElizaF
Creator II
Creator II

Hi Murali,

You can use the conditional layout for list box.

See attached the app.

Hope to help you.

!

View solution in original post

7 Replies
ElizaF
Creator II
Creator II

Hi Murali,

You can use the conditional layout for list box.

See attached the app.

Hope to help you.

!

View solution in original post

MuraliPrasath
Creator III
Creator III
Author

Hi Eliza,

This is cool and in addition to this, How to make ID field as a default selection when we open the qvw?

Thanks,

Murali

ElizaF
Creator II
Creator II

Hi,

What means "default selection when we open the qvw"

You can have default value for one dimension when open the qwd and can be implemented through Document properties --> Triggers

07-04-2017 12-18-45 PM.png

MuraliPrasath
Creator III
Creator III
Author

Thank you! You saved my time! Have a good day.

ElizaF
Creator II
Creator II

I am glad it did help.

Have a nice day !

Eliza

MuraliPrasath
Creator III
Creator III
Author

Hi Eliza,

I've one more question regarding this.

How to clear only 'Month Dimension' or 'Year Dimension' List box fields when we click on the buttons, instead of clearing all selections on the dashboard?

Thanks,

Murali

ElizaF
Creator II
Creator II

Try this solution.

10-04-2017 10-01-58 AM.png10-04-2017 10-02-10 AM.png