Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Sheet Selection in drop down

Hi

My requirement is like below

Select Report Name: Report A or Report B or Report C

Based on user selection my report should display. How can i achieve above one.It like prompt value selection.

Thanks

Govind R

1 Solution

Accepted Solutions
arulsettu
Honored Contributor III

Re: Sheet Selection in drop down

for desktop

download the extension and extract it. then copy it to the following path

C:\Users\%USERNAME%\Documents\Qlik\Sense\Extensions


reopen the app the extension will appear

9 Replies
sureshqv
Esteemed Contributor III

Re: Sheet Selection in drop down

arulsettu
Honored Contributor III

Re: Sheet Selection in drop down

hide and show not possible in qlik sense

Not applicable

Re: Sheet Selection in drop down

If you are maintaining "Report A/B/C" in a column. Then apply OnSelect trigger on that column.

Activate Sheet Action:

               If(GetFieldSelection(Column_Name)='Report A', 'SH01',

                 If(GetFieldSelection(Column_Name)='Report B', 'SH02','SH03'))

phaneendra_kunc
Valued Contributor III

Re: Sheet Selection in drop down

Govind,

So how do user access the app? is it through hub? if so then when they open the app they will see all sheets in the App Overview screen. If you are planning to hide them even in the App over view screen then you have below options.

1. QMC --> Security Rules

Define 3 rules for 3 sheets in the published app on who can access what sheet.

Example : Sheet1 & Sheet2 from App1 should be visible to User 1 and User2

                Sheet2 & Sheet4 from App1 should be visible to User 3 and User2

Doing this way you don't have to control using dropdown/custom mashup/extension.

This option will hide the sheets even on the app over view screen based on who logs in.

2. Extension

Qlik Branch

Install this extension and use the actions to navigate from one sheet to another.

This option will not hide the sheets on the app over view screen.


3. Some more extension

Tabs - Qlik Branch

Drop down - Qlik Branch

This option will not hide the sheets on the app over view screen.


4. Custom Mashup

https://<servername>/dev-hub

You have to create a custom mashup and some authentication around who sees what. This needs HTML/CSS/Java Expertise.

This option will hide the sheets based on who logs in.

phaneendra_kunc
Valued Contributor III

Re: Sheet Selection in drop down

Neha,

Your method works only in Qlikview and we are talking about Qlik Sense.

Not applicable

Re: Sheet Selection in drop down

Dear All,

Thanks a lot.Really very helpful will check above documents and let you know

Thanks

Govind R

Not applicable

Re: Sheet Selection in drop down

How to install multiple tabs.

Can you please give me steps pls. I am not able to understand. below documents

http://branch.qlik.com/?&_ga=1.193433455.312404886.1470297364#!/project/56728f52d1e497241ae6984f

arulsettu
Honored Contributor III

Re: Sheet Selection in drop down

for desktop

download the extension and extract it. then copy it to the following path

C:\Users\%USERNAME%\Documents\Qlik\Sense\Extensions


reopen the app the extension will appear

Not applicable

Re: Sheet Selection in drop down

Drop Down sheet not able to see download files.

sheetList dropdown list extension

Can you please let me know where can get attachment.

Thanks a lot.I achieved tab as well pre and next features.

Community Browser