topic Re: Force users to select multiple fields before they get to see the whole sheet/Tab in QlikView

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

BootCam — Sat, 16 Nov 2024 21:40:17 GMT

Hi All,

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

Thanks,

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

uacg0009 — Wed, 02 Jan 2019 03:44:07 GMT

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

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

BootCam — Wed, 02 Jan 2019 08:03:13 GMT

Hi Uacg0009,

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

Best,

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

uacg0009 — Wed, 02 Jan 2019 08:06:43 GMT

Hi,

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

Aiolos Zhao

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

BootCam — Wed, 02 Jan 2019 08:14:58 GMT

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,

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

uacg0009 — Wed, 02 Jan 2019 08:26:20 GMT

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

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

BootCam — Wed, 02 Jan 2019 08:38:41 GMT

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,

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

uacg0009 — Wed, 02 Jan 2019 09:09:33 GMT

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.

Aiolos Zhao

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

BootCam — Wed, 02 Jan 2019 09:12:02 GMT

Excellent Uacg0009 !

Thanks for the solution.

Best,

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

uacg0009 — Wed, 02 Jan 2019 09:20:01 GMT

You're welcome.
Glad to help you~