topic Re: reportable vs non reportable in QlikView

reportable vs non reportable

manoranjan_d — Tue, 15 Nov 2016 09:16:02 GMT

Hi all

in table 1 name and code field is re portable data, table 1 is the base table of reportable data

table 2 name and code field is is mixed of reportable and unreportable data.

now i need a list box name called reportabilty in the front end with a value of reportable and unreportable

where if the user select the reportable from list box it shd the reportable names of the table1 and table 2, similiar tot the unreportable

how to do this in the coding

Gysbert_Wassenaar — Tue, 15 Nov 2016 10:08:14 GMT

Something like this:

table1:

LOAD

code as repcode,

name

FROM

...somewhere...

;

table2:

LOAD

code,

name,

ADDRSS,

ID,

If(Exists(repcode,code),'Reportable','Non reportable') as Reportablility

FROM

...somewhereelse...

;

DROP TABLE table1;