Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
balanandam
Creator II
Creator II

Create Control Page in Qlikview

Hi,

I have common Dashboard for different products. I wanted to create some control page which was only displayed initially to the user when they did click the .qvw from Qlikview access point, there it will have some options to choose like Product, Language, ...etc. Based on user option from Control page, rest all views will be decided and visible.

Is there any best way to do this ?

Thanks!

Balanandam

1 Solution

Accepted Solutions
balanandam
Creator II
Creator II
Author

Shoham, Thanks for your suggestion. I could have used one variable. Actually,this is not customer requirement, we've Dashboard which was created our in-house team in java and we've adopted recently Qlik and we should migrate all customer apps to Qlik asap. So, every thing must be same as is unless there must be ask. May be I'll convey this later point of time.

Thank Q

View solution in original post

6 Replies
prieper
Master II
Master II

Show the tab only, if certain variables are populated, e.g.

Properties -> General -> Show Sheet

= LEN(vLanguage) > 0 AND LEN(vProduct) > 0 etc

Likewise you may show certain Fields and then the condition will be similar

= WILDMATCH(GETCURRENTSELECTIONS(), '*ProductField*') AND WILDMATCH(GETCURRENTSELECTIONS(), '*Language*') etc

techvarun
Specialist II
Specialist II

Create a sheet (Like Home page) with mandatory fields and buttons.

Once the user selected all the filters navigate the users to desired tab using button action.

Hid tab arrows and set a trigger at Document Properties---> Trigger -----> On-open to display the home page

Or
MVP
MVP

Peter's response above covers the basic idea, but just a quick tip - instead of checking fields or variables for being marked, if you want this landing page to only display once, create a vShowLandingPage variable in your QVW, set it to 1 by default, and add an OnLeaveSheet trigger for the control sheet that sets it to 0. Place this variable in the Conditional section of the Show Sheet option.

balanandam
Creator II
Creator II
Author

Thanks you! Peter, Varun & Shoham. It helps so much.

I wanted My Dashboard in  below way...

When I opened .qvw, it should be display only Control Page, after user selection, user hits submit button it enables rest all tabs and vanish the Control or Home page. This should be remain as is every time user opened Dashboard. qvw.

So, what I did here is, I created two variables vShowLandingPage and vShowViews, I set vShowLadingPage=1, which opens landing page initially and vShowViews=0 which hides other views, after user selection on Home page and submit button at same Home page, values of these two variables get exchange i.e, vShowLandingPage=0 and vShowViews=1. So, now Home page gone and rest all tabs will appears...

As of now I'm okay with this, but, appreciates, is there any best way that makes client more happy other than this ?

I guess, I'm asking many questions, but, I don't have option since I'm very new to Qlikview.

Once again Thanks!

Regards, Balanandam

Or
MVP
MVP

It sounds like you've got it about right - though you could have just used a single variable if you wanted, rather than two, the result is the same.

I'm not sure why your client would be unhappy about you doing exactly what they asked, so I can't say if there's a way to make them happier. Conceptually, I don't like using landing pages in QV - I feel that it lowers usability. I prefer a starting sheet and a default set of selections (which can be set based on the user logging in) to a menu / landing page. However, customer requirements are customer requirements..

balanandam
Creator II
Creator II
Author

Shoham, Thanks for your suggestion. I could have used one variable. Actually,this is not customer requirement, we've Dashboard which was created our in-house team in java and we've adopted recently Qlik and we should migrate all customer apps to Qlik asap. So, every thing must be same as is unless there must be ask. May be I'll convey this later point of time.

Thank Q