topic Re: If statements in QlikView

If statements

Wed, 25 Nov 2020 16:16:04 GMT

Hey Guys,

I have an excel file in the attachment where I have collected 15 minutes values of climate data from 01/01/2015 to 31/12/2015.

I have the following columns:

- Begin

- Eind

- Piek

- Dal

- Gas

and i have used the Begin column to create my calendar as shown below

LOAD

Begin,

Month(Begin) AS Maand,

Year(Begin) AS Year,

Day(Begin) AS DagvdMaand,

WeekDay(Begin) AS DagvdWeek,

Hour(Begin) AS Uur,

Eind,

Piek,

Dal,

Gas,

FTE,

BVO

So I want to write an expression as follows:

If the sum of the Piek+Dal = 0 or empty for any of the months, then 365 minus those days in the months that have zero or empty values. I don't know how to go about it. Please any help in figuring these out will be truly appreciated.

Thanks

Re: If statements

its_anandrjs — Wed, 16 Mar 2016 10:08:13 GMT

Try this ways

LOAD

Begin,

Eind,

Piek,

Dal,

Gas,

FTE,

BVO,

If( Piek+Dal = 0, 365 - [Your Days Field Here], [Your Days Field Here]) as CalculatedField

FROM

(ooxml, embedded labels, table is Blad1);

Note:- [Your Days Field Here] this is your days field add your field here in place of my field.

Regards,

Anand

Re: If statements

Digvijay_Singh — Wed, 16 Mar 2016 19:54:21 GMT

Check if this can help, front end based -

=365-Sum(Aggr(if(rangesum(sum(Piek)+Sum(Dal))=0,1),Maand,DagvdMaand))