topic Re: Different scenario in QlikView

Different scenario

Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

I have following kind of data.

I want count against Emp ( dimension: Emp). It should be counted when Key is exist in Pkey when issue LDT only on name of john.

Anil_Babu_Samineni — Fri, 14 Apr 2017 13:12:57 GMT

Would i know expected output from given data

Fri, 14 Apr 2017 13:18:47 GMT

Emp Issues ( Count)

Julee 0

John 1

Anil_Babu_Samineni — Fri, 14 Apr 2017 14:04:10 GMT

May be this expression

Count(DISTINCT {<Pkey = {''}>} Key)

vishsaggi — Fri, 14 Apr 2017 14:05:49 GMT

May be this? Not sure if that works with more data. Just let us know.

LOAD *, IF(Key = Previous(Pkey), 1, 0) AS KeyCnt INLINE [

Emp, Issue, Key, Pkey,

Julee, LDT, a113, a112

John, Worked, a112

];

Use straight table and

Dim: Emp

Expr: Keycnt

Sat, 15 Apr 2017 10:25:12 GMT

No.

I mean when pkey is exist in key then it should counted 1 on name who worked on that. Should not counted who Lost.

2. It's not exactly above or below the record. It can be any line @vishwanath

Anil_Babu_Samineni — Sun, 16 Apr 2017 06:55:49 GMT

Try this? Count({<Key=P(Pkey)>} Pkey)