topic Re: show /hide sheets based on listbox selection in QlikView

show /hide sheets based on listbox selection

anat — Thu, 18 Jun 2015 09:58:25 GMT

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

..........

Re: show /hide sheets based on listbox selection

alexandros17 — Thu, 18 Jun 2015 10:13:29 GMT

Here is my example

Re: show /hide sheets based on listbox selection

aveeeeeee7en — Thu, 18 Jun 2015 10:22:41 GMT

Alessandro Sir Awesome Solution.

Re: show /hide sheets based on listbox selection

vardhancse — Thu, 18 Jun 2015 10:23:39 GMT

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

We can give the field value and condition

Re: show /hide sheets based on listbox selection

anat — Thu, 18 Jun 2015 10:28:30 GMT

@Alessandro Saccone ,

superb Solution.

Re: show /hide sheets based on listbox selection

Thu, 18 Jun 2015 10:44:50 GMT

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


Product	ProdName	Price	Updated	From	To Date
123	Watch	150$	1/1/2015	1/1/2015	4/30/2015
123	Watch	125$	5/1/2015	5/1/2015	5/42015
123	Watch	119$	5/5/2015	5/5/2015	6/18/2015

Help me implementing the same.

Thanks in advance

Re: show /hide sheets based on listbox selection

anat — Thu, 18 Jun 2015 11:05:25 GMT

123

Watch

119$

5/5/2015

6/18/2015

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

Re: show /hide sheets based on listbox selection

Thu, 18 Jun 2015 11:09:16 GMT

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

Re: show /hide sheets based on listbox selection

anat — Fri, 19 Jun 2015 08:34:26 GMT

@ruchi rathi : may be this link will help you

Creating a Date Interval from a Single Date