Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
anat
Contributor

show /hide sheets based on listbox selection

Hi,

In my application we have implemented total 5 sheets like SheetA,SheetB,SheetC,SheetD,SheetE.

one dim column contain data like (ListBox data )

SheetA

SheetB

SheetC

SheetD

SheetE

my requirement is:

1)in list box if i select SheetA then SheetA tab should be enable.

2)suppose  if i select SheetA and SheetB  then SheetA tab  and SheetB tab should be enable.

3)if i select all values in list box all tabs should be enable.

Regards

..........

1 Solution

Accepted Solutions

Re: show /hide sheets based on listbox selection

Here is my example

View solution in original post

8 Replies

Re: show /hide sheets based on listbox selection

Here is my example

View solution in original post

aveeeeeee7en
Valued Contributor III

Re: show /hide sheets based on listbox selection

Alessandro Sir Awesome Solution.

vardhancse
Valued Contributor III

Re: show /hide sheets based on listbox selection

Hi

In sheet properties-General<tab>->Show Sheet:

We can give the field value and condition

sheet.JPG

anat
Contributor

Re: show /hide sheets based on listbox selection

@Alessandro Saccone ,

superb Solution.

Not applicable

Re: show /hide sheets based on listbox selection

Hi Sasi,

Kindly help me resolve the following query using the SCD solution

Well, I have the following Inline table

LOAD * INLINE

[

    Product, ProdName, Price, Updated

    123, Watch, 150$, 1/1/2015

    134, Fruit, 30$, 1/1/2015

    145, Ring, 3000$, 3/1/2015

    123, Watch, 125$, 5/1/2015

    123, Watch, 119$, 5/5/2015

    134, Fruit , 50$, 5/5/2015

    145, Ring, 2500$, 5/12/2015

    234, Pen, 12$, 5/17/2015

    312, Jeans, 50$, 6/9/2015

];

Using the above input table, I need to get the below reults

ProductProdNamePriceUpdatedFromTo Date
123Watch150$1/1/20151/1/20154/30/2015
123Watch125$5/1/20155/1/2015     5/42015
123Watch119$5/5/20155/5/20156/18/2015

Help me implementing the same.

Thanks in advance

anat
Contributor

Re: show /hide sheets based on listbox selection

123Watch119$5/5/20155/5/20156/18/2015

here what is the logic for 6/18/2015? how u r populating this record(6/18/2015)?

Not applicable

Re: show /hide sheets based on listbox selection

6/18/2015 is nothing but Today's Date

anat
Contributor

Re: show /hide sheets based on listbox selection

@ruchi rathi : may be this link will help you

Creating a Date Interval from a Single Date