topic Can anyone help me in activating sheets? in QlikView

Can anyone help me in activating sheets?

durgabhavani — Fri, 17 Apr 2015 04:21:42 GMT

Hi All,

I have three sheets(tabs) in my qlikview application. (say accounts, sales, billing)

Now i want to display

-> Sheet accounts for particular time period 9 AM to 10 AM (60 mins).

-> Sheet sales for particular time period 10 AM to 10.30 AM (30 mins).

-> Sheet billing for next time period 10.30 AM to 12 PM (90 mins).

Note: when one sheet is displaying no other sheet not to be displayed.

Please advice!

Thanks,

Durga

Re: Can anyone help me in activating sheets?

Anonymous — Fri, 17 Apr 2015 05:19:39 GMT

You can create a variable which holds the current system time and use this variable to hide/show the sheets.

Define the variable as vNow =num(SubField(now(),' ',2))

Now go to sheet properties of Accounts sheet and under General tabl select Conditional and give a condition like this

$(vNow)>= num(time('9:00:00', 'h:mm:ss')) and $(vNow) <=num(time('10:00:00', 'h:mm:ss'))

Similarly you can add for Sales and billing sheet.

Regards,

Greeshma

Re: Can anyone help me in activating sheets?

Anonymous — Fri, 17 Apr 2015 05:22:59 GMT

try in sheet properties conditional show like

for account sheet

=if((text(Time(class(Frac(Now()),1/24/60),'hh:mm'))>'09:00') and (text(Time(class(Frac(Now()),1/24/60),'hh:mm'))<='10:00') ,1,0)

sales

=if((text(Time(class(Frac(Now()),1/24/60),'hh:mm'))>'10:00') and (text(Time(class(Frac(Now()),1/24/60),'hh:mm'))<='10:30') ,1,0)

Billing

=if((text(Time(class(Frac(Now()),1/24/60),'hh:mm'))>'10:30') and (text(Time(class(Frac(Now()),1/24/60),'hh:mm'))<='12:00') ,1,0)

Thanks

BKC

Re: Can anyone help me in activating sheets?

petter — Fri, 17 Apr 2015 05:30:38 GMT

Yet another solution which is very similar to the others

Re: Can anyone help me in activating sheets?

durgabhavani — Fri, 17 Apr 2015 05:40:33 GMT

Thanks for Every response!

I implemented everything and everthing is working exactly what i required.

@Greeshma: your condition is very simple and easy to understand and works fine.

@BKC: I think you are coding expert! it works fine. Can you please explain what 1/24/60 means in your expression and i am looking into Frac function first time. Happy to learn new things.

@Peter: works fine!

Once again thanks everyone!

Durga