Pop Up Box Code required to choose a particular metric and the corresponding dashboard

[rajtechnocraft]

Hi All,

i wanted to design a choice box for selecting KPI's(Metrics)

It should have a pop up box and ask the user to confirm the metric which he wants to see .The moment he confirms that particular dashboard should then appear to the corresponding metric chosen.

This help is required on urgent basis

Hoping to expect replies from QV experts.

Please note that i don't want multibox object

Regards

Raj

[kaushiknsolanki]

Hi,

    Do you mean that user should select one KPI from a chart and a chart should show according to the selected KPI.

    If yes then you can add all the KPI's in Chart Expression and create a group, which will include all the KPI's. (To create a group, there a Group button in expression window). This will show a Drill down to user from where he can select the KPI for the chart.

    Hope this will help.

Regards,

Kaushik Solanki 

[rajtechnocraft]

Hi Kaushik,

Thanks for the reply

What i want to achieve is for each KPi present i have sheets(Tabs) present in the application..

I want to replace these tabs with menu drive interface.

So a user should get a list ok KPI's available.

The moment he selects particular KPI that tab should be visible otherwise hidden by default unti and unless there is a selection..

The reason i want to have menu is there are close to 30 tabs in my application.So the user gets confused when he has to look for particular metric.

Thanks in advance

[kaushiknsolanki]

Hi,

    Ok, then let me tell you how you can do this.

    Create a inline table with all KPI's as shown below

     KPI_LIST:

     load * inline [

     KPI

     Sum(Field1)

     Count(Field1)

     ];

     Now Create a variable Say vVisibility

     Now at every sheet for KPI make changes like this.

     Goto properties of sheet -> General tab -> Show sheet ->  Click on Conditonal and type this expression.

     vVisibility = 1 ( Say for First KPI)

     Same way for Second KPI

     vVisibility = 2

     Same way for other KPI's

     Now at the first Sheet Place a listbox for field KPI

     Now create a button. with action as external -> set variable ->

     Here type Variable name as vVisibility.

     And value as

     if(KPI = 'sum(Field)',1,

        If(KPI = 'Count(Field)',2))

    Logic :

    On selection of a KPI from KPI listbox a variable will be set and depending on that variable a sheet will be visible.

    Hope you understood.

Regards,

Kaushik Solanki    

[rajtechnocraft]

Hi Kaushi,

Can u please send a sample qvw

I tried but i am not able to control visibility/invisibility of sheets.

Regards

Raj

[kaushiknsolanki]

Hi,

   At present i dont have Qlikview in my Laptop.

   But sure very soon i will send you that.

Regards,

Kaushik Solanki

[rajtechnocraft]

Hi Kaushik ,

I have used the following macro code

Sub open Loans

set v=ActiveDocument.Variables('Loans')

ActiveDocument.ActivateSheetByID"SH91"

V.setcontent"1",true

end sub

Sub closeLoans

set v=ActiveDocument.Variables("Loans")

ActiveDocument.ActivateBySheetID"SH91"

V.setcontent"0"ActivateSheetByID"SH91"

end sub

i am facing difficulty in making the value for variable lOans behave dynamically.ie automatically change from 1 to 0

Can u help me in this macro code

Regards

Arvind