Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

sivaprakash_t
New Contributor

calculate incidents in a month

Hi guys,

I want to calculate cases by Branchcode/Ip_address,month wise in script level, Please find the sample data...Please help me out this issue.I'm manually calculate flag in attached data

Capture.JPG

Tags (1)
1 Solution

Accepted Solutions

Re: calculate incidents in a month

Input:

LOAD IP_Address,

     BranchCode,

     IP_Address & BranchCode as Key,

     [Case ID+],

     [Down Since],

     Month([Down Since]) as Month,

     [Up Since],

     Flag

FROM

[222759.xlsx]

(ooxml, embedded labels, table is Sheet2);

Left Join (Input)

Load Key, Count(Month) as Flag2 Resident Input

Group By Key;

Drop Field Key;

3 Replies
galax_allu
Valued Contributor

Re: calculate incidents in a month

Hi

try this pivot table ?

aggr(count(BranchCode),BranchCode)

MindaugasBacius
Valued Contributor II

Re: calculate incidents in a month

Try this:

Aggr(Count(BranchCode), BranchCode, IP_Address)

Screenshot_2.jpg

Outcome:

Screenshot_1.jpg

Re: calculate incidents in a month

Input:

LOAD IP_Address,

     BranchCode,

     IP_Address & BranchCode as Key,

     [Case ID+],

     [Down Since],

     Month([Down Since]) as Month,

     [Up Since],

     Flag

FROM

[222759.xlsx]

(ooxml, embedded labels, table is Sheet2);

Left Join (Input)

Load Key, Count(Month) as Flag2 Resident Input

Group By Key;

Drop Field Key;

Community Browser