topic Re: No data in QlikView

No data

upaliwije — Fri, 17 Aug 2018 06:29:33 GMT

Dera Friends,

I have developped a QV document but it does not show any data once I run it It does not show any data. My rquirement is to obtain an out report like shown below. Pls help me

POLICY_NO PERIOD_TO PERIOD_FROM NRP BCOD Month_Year PRD_CODE REF_NO TRN_DATE PFLAG

DB00141C0001578 04-12-18 05-12-17 -28734 N100 Feb-2018 1C N10018C0000648 05-02-18 X

DB00141C0001578 04-12-18 05-12-17 28734 N100 Dec-2017 1C N10017D0001912 05-12-17 X

DB00151C0001688 17-11-18 18-11-17 -14903 N100 Mar-2018 1C N10018C0000658 05-03-18 X

DB00151C0001688 17-11-18 18-11-17 14903 N100 Nov-2017 1C N10017D0001874 18-11-17 X

DB00161A0001362 29-08-18 30-08-17 -17827 N100 Jan-2018 1A N10018C0000635 05-01-18 X

DB00161A0001362 29-08-18 30-08-17 28711 N100 Aug-2017 1A N10017D0001667 30-08-17

Two X hilighted in red should appear.

Re: No data

tresB — Fri, 17 Aug 2018 06:36:11 GMT

Your second table is probably getting auto-concatenated and dropped as an entire table. Try using NoConcatenate statement before the second table load like:

Re: No data

upaliwije — Fri, 17 Aug 2018 06:57:39 GMT

Thanks for your reply it works. Can you please look into my output with PFFLAG hilighted in red. That red X I am getting in my output.

Re: No data

tresB — Fri, 17 Aug 2018 08:37:07 GMT

Are you trying to get the filtered output in chart using or in the script itself? Try to share your qvw file with data.

Re: No data

upaliwije — Fri, 17 Aug 2018 09:40:02 GMT

In the script it self . I have already shared my qvw file and data please

Re: No data

tresB — Fri, 17 Aug 2018 10:06:00 GMT

Data load order is important for such statements. I removed your Order By clause from second load, and seemed worked. Try it.

Re: No data

BalaBhaskar_Qlik — Fri, 17 Aug 2018 10:11:35 GMT

May be like this:

=If(Sum([Current] - [Original]) < 1 and [DISCUSSION FLAG] = 'X', Green(), If([AT RISK] = 'X', Yellow(), Red()))

=If(IsNull(Field),Red(),White())