Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Problem to calculate the days

Hello i am new in Qlikview and i want do calculate the days (OPTTAG).

The Problem:

as you can see i try to calculate the OPTTAGE.

For example when i make a sum, then i should get for Bern Tisch 1 for the first Jan 0,5 and not 1,5.

I get the total form all the Fallnummern, but i dont need this.

below you see the script, i tell them if the SNZ is biger than 0.1562500000, then he should count 1 day, if the SNZ is lower than 0.1562500000 then count 0,5 days.

I need the SNZ for the OPSaal not for the Fallnumer.

What do i have to write, to get the sum for the OPSaal per day and not for the Fallnummer.

Please i need some help.

TMPTermine:

LOAD Fallnummer,

     OPSaal,

     Schnitt,

     Naht,

     Timestamp#(Naht,'hh:mm')                                 as NahtZeit,

     Timestamp#(Schnitt,'hh:mm')                            as SchnittZeit,

     right(Timestamp(Schnitt),8)                            as Schnittzeit,

     right(Timestamp(Naht),8)                                as Nahtzeit,

     interval(Naht-Schnitt,'hh:mm')                         as SNZ

    

FROm

(ooxml, embedded labels, table is Tabelle1);

Termine:

Load

Fallnummer,

OPSaal,

Schnitt,

year(Schnitt)                                        as Jahr,

Month(Schnitt)                                        as Monat,

day(Schnitt)                                        as Tag,

Schnittzeit,

Naht,

Nahtzeit,                                       

sum(SNZ)                                                    as #SNZ,

if(sum((SNZ))>='0.1562500000',1,0.5)                        as OPTTag

Resident TMPTermine

Group by

Fallnummer,

OPSaal,

Schnitt,

year(Schnitt),                                       

Month(Schnitt),                                       

day(Schnitt),

Schnittzeit,

Naht,

Nahtzeit;

Drop Table TMPTermine;

Community Browser