topic show sheet condition in QlikView

show sheet condition

Tue, 18 Jul 2017 06:56:05 GMT

Dear Team,

I have set a show sheet condition as below. Meaning when the variable hit the value and sheet will show. Everythig is working fine,.

Below is my report view. But my question is, below is my view, it actually is a straight table. I want to know how do i put a condition if straight table contains no data then hide the sheet.

Re: show sheet condition

jonathandienst — Tue, 18 Jul 2017 07:06:20 GMT

You need an expression that calculates the number of rows, and compare that expression to zero in the Properties | Layout | Show conditional box. For example

Count(DISTINCT dimension) > 0

Re: show sheet condition

effinty2112 — Tue, 18 Jul 2017 07:23:12 GMT

Hi Chee,

If you have one expression and N dims in your straight table then try:

Count(Aggr(Expr1,Dim1,Dim2, ..., DimN)) >0 as the show condition for the sheet.

If you have more than one expression, say M then try

Max(

Count(Aggr(Expr1,Dim1,Dim2, ..., DimN)) ,

Count(Aggr(Expr2,Dim1,Dim2, ..., DimN)) ,

Count(Aggr(ExprM,Dim1,Dim2, ..., DimN))

) >0

I've never did this before and so haven't checked it so if you try it please let me know how it goes.

Cheers

Andrew

Re: show sheet condition

antoniotiman — Tue, 18 Jul 2017 07:26:48 GMT

Conditional :

vShow=1 and Sum(Aggr(1,Employee,StartTime,Job,..)) > 0

Regards,

Antonio

Re: show sheet condition

Tue, 18 Jul 2017 08:38:32 GMT

what if my page of data is chart instead of straight table?

Re: show sheet condition

antoniotiman — Tue, 18 Jul 2017 08:52:12 GMT

You wrote

' if straight table contains no data then hide the sheet.'

Employee,StartTime,.. are Dimensions of Your Straight Table

Re: show sheet condition

Wed, 19 Jul 2017 01:45:55 GMT

Hi Antonio,

what if my chart dimesion is calculated dimension instead of fixed field. for example

If(VS='VSR' and No=2, JOB_NO )

Re: show sheet condition

antoniotiman — Wed, 19 Jul 2017 04:35:12 GMT

Try

Sum{<VS={'VSR'},No={2}>} Aggr(1,JOB_NO,Dim,..)) > 0

Sum(Aggr(If(VS='VSR' and No=2, 1,0),JOB_NO,Dim,...)) > 0

Re: show sheet condition

Wed, 19 Jul 2017 04:38:00 GMT

what is the DIM,..... after JOB_NO??

Re: show sheet condition

antoniotiman — Wed, 19 Jul 2017 04:41:39 GMT

Other Dimensions (Employee,StartTime,..)

Re: show sheet condition

Wed, 19 Jul 2017 05:20:50 GMT

Or do you want to take a look of my file. actually if u use Ctrl+Shift+ 'S' and it will show all the sheet. But i have a condition to show only one sheet every 15 sec. so for sheet 'Chart1', Chart2 and CHart 3 are newly put in one.

The Chart 2 table contains no data. anyway for me to skip the chart 2? I have include your formula but it's not working.

Below is the link for the file

https://drive.google.com/file/d/0B6c7Q2c9qyF3aGhzUHNaWTMzdlk/view?usp=drivesdk

Re: show sheet condition

antoniotiman — Wed, 19 Jul 2017 05:42:00 GMT

In this case Dimensions > 0 and Expressions are 0

You need add Expressions in Conditional like this

=vShow=5 and Sum(Aggr(If(VS='VSR' and No=2 and (Repair <> 0 or Scrap <> 0 or OtherExp <> 0, 1,0),JOB_NO)) > 0 and Repair <> 0

Re: show sheet condition

Wed, 19 Jul 2017 05:45:47 GMT

you mean i need to include all the dimension as well? cause i have 10 over dimension actually in place. Can you use my example and amend? to see whether the sheet named 'Sheet2' appear or not?

Re: show sheet condition

Wed, 19 Jul 2017 06:01:26 GMT

Hi Jonathan,

Can elaborate more on this?? what if dimension is calculated dimension? If(VS='VSR' and No=2, JOB_NO )