Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
anat
Master
Master

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
alexandros17
Partner - Champion III
Partner - Champion III

Here is my example

View solution in original post

8 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Here is my example

aveeeeeee7en
Specialist III
Specialist III

Alessandro Sir Awesome Solution.

vardhancse
Specialist III
Specialist III

Hi

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

We can give the field value and condition

sheet.JPG

anat
Master
Master
Author

@Alessandro Saccone ,

superb Solution.

Not applicable

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
Master
Master
Author

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

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

anat
Master
Master
Author

@ruchi rathi : may be this link will help you

Creating a Date Interval from a Single Date