topic Re: QlikView Logic Implementation in QlikView

QlikView Logic Implementation

ujjwalraja — Thu, 11 Oct 2018 14:41:00 GMT

Hi Qlik Team,

I have data as following

key	receipt
1	0
1	122
1	256
2	0
3	0
3	256
4	586

The requirement is to fetch only those key for which no receipt has been generated. Here the output should be key 2

Please suggest logic , I have to do it in back-end.

Thanks

Re: QlikView Logic Implementation

vamsee — Thu, 11 Oct 2018 14:44:15 GMT

LOAD

From Table

Where

Num(receipt) > 0;

Re: QlikView Logic Implementation

ujjwalraja — Thu, 11 Oct 2018 14:47:32 GMT

This will give 1,3 and 4

Re: QlikView Logic Implementation

Anil_Babu_Samineni — Thu, 11 Oct 2018 14:50:50 GMT

You want this in Script / UI?

Re: QlikView Logic Implementation

ujjwalraja — Thu, 11 Oct 2018 14:52:21 GMT

script

Re: QlikView Logic Implementation

vamsee — Thu, 11 Oct 2018 15:07:55 GMT

Maybe try

Source:

LOAD * Inline [

key, receipt

1, 0

1, 122

1, 256

2, 0

3, 0

3, 256

4, 586

];

Min:

LOAD key as Key_Check

Where minvalue=0;

LOAD

key,

min(receipt) as minvalue

Resident Source

Group by key;

Final:

NoConcatenate

LOAD

Resident Source

Where Not Exists (Key_Check, key);

Drop Tables Min, Source;

Re: QlikView Logic Implementation

raman_rastogi — Thu, 11 Oct 2018 15:11:18 GMT

May be like this

Input1:

Load * Inline [

Key , reciept

1, 0

2, 0

3, 0

1, 122

1, 256

3, 256

4, 586

];

NoConcatenate

I2:

LOAD *, Key as Keycheck RESIDENT Input1

WHERE reciept <>0;

CONCATENATE

LOAD *, Key as Keycheck RESIDENT Input1

WHERE reciept =0 and not exists(Keycheck,Key);

NoConcatenate

Load

Key ,reciept Resident I2 where reciept=0;

Drop table Input1;

Drop table I2;

Regards

Raman

Re: QlikView Logic Implementation

snehamahaveer — Thu, 11 Oct 2018 15:12:28 GMT

Hello Ujjwal,

I would suggest loading like

Load

Key,

sum(Receipt) as Total

from table

Group by Key;

and then do

Table 2:

Load

Key

Resident table

where Total = 0;

Hope this helps.

Regards

Sneha