Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
BootCam
Creator
Creator

Force users to select multiple fields before they get to see the whole sheet/Tab

Hi All, 

 

Is there a way to force users to select multiple fields before they get to see the whole sheet/Tab?

 

Thanks,

BC 

Labels (1)
1 Solution

Accepted Solutions
uacg0009
Partner
Partner

Sure you can do it.

There is another function in qlikview. Right click the chart, choose properties,in "General" tab.

You can move your "condition" expression to the "Calculation Condition", then you can see the "Error Message",

click it, then you can type the message in the "Custom Message".

Please try.

Force users to select multiple fields before they get to see the whole sheet Tab2.PNG

Aiolos Zhao

View solution in original post

9 Replies
uacg0009
Partner
Partner

Hi BootCam,

I think you can use the "Condition" in Tab Properties,like:

= not isnull(GetFieldSelections(Field1)) and not isnull(GetFieldSelections(Field2)) and not isnull(GetFieldSelections(Field3))

Please try.

Aiolos Zhao

BootCam
Creator
Creator

Hi Uacg0009,

 

Thanks for your replies. Sheet/Tab Properties exactly where i should use the condition?

 

Best,

BC

uacg0009
Partner
Partner

Hi,

Right click in the sheet, and choose Properties. Then you can see below "Show Sheet" function:

Force users to select multiple fields before they get to see the whole sheet Tab.PNG

Aiolos Zhao

BootCam
Creator
Creator

Hi Uacg0009,

 

The solution works for me but the users gonna get freaked out if they dont see tab and have to navigate from another Tab. 

Is there any way we can do that within the same sheet/tab ?

 

Best,

BC

uacg0009
Partner
Partner

Hi,
Actually every charts or objects also have this function,
eg. you can right click a chart, choose properties.
and in "Layout" tab, you can see the same function in "Show".
so if you have 4 charts, then you need to set all charts with this "condition", then after user select what you want, then the tab will show the whole 4 charts together.
Aiolos Zhao
BootCam
Creator
Creator

Hi Uacg0009,

 

Yes, this is the solution i need. One last thing, Can i show a custom message on the chart that says, please select these dimensions to show the chart.

 

Best,

BC

uacg0009
Partner
Partner

Sure you can do it.

There is another function in qlikview. Right click the chart, choose properties,in "General" tab.

You can move your "condition" expression to the "Calculation Condition", then you can see the "Error Message",

click it, then you can type the message in the "Custom Message".

Please try.

Force users to select multiple fields before they get to see the whole sheet Tab2.PNG

Aiolos Zhao

View solution in original post

BootCam
Creator
Creator

Excellent Uacg0009 !

Thanks for the solution.

 

Best,

BC

uacg0009
Partner
Partner

You're welcome.
Glad to help you~