FirstSortedValue : We have to find the tables from table1 which are not present in table 2.

sachin1 — Fri, 15 Nov 2024 20:56:33 GMT

Table1:
Load * inline [

Program , Table_Name
LP , A
LP , B
LP , C
LP , D
LP , E
LP , F
];

Table2:

Load * inline [

Program ,Tablename, Status
LP , A , Gold
LP , B , Gold
LP , C , Gold
LP , A , Silver
LP , B , Silver
LP , C , Silver

];

We have to find the tables from table1 which are not present in table 2.

I have used logic for Count Column : count(TOTAL DISTINCT Table_Name) - Count({<Status={"Gold"}>}DISTINCT Tablename) and getting output 3 so we want that 3 missing data in Missing column.

And I tried logic for Missing Column : FirstSortedValue(Tablename,-Aggr((Count({<Status={"Gold"}>}DISTINCT Tablename)) -(count(total DISTINCT Table_Name)),Tablename,Table_Name)) - This logic is not worked.

We Want output below:

Table_Name	Count	Missing Column
	3
A	3
B	3
C	3
D	3	D
E	3	E
F	3	F

Re: FirstSortedValue : We have to find the tables from table1 which are not present in table 2.

maxgro — Mon, 17 Jun 2024 08:43:22 GMT

try with

Only({$ <Table_Name-=P({1 <Status={Gold}>} Tablename)>} Table_Name)

https://help.qlik.com/en-US/qlikview/May2024/Subsystems/Client/Content/QV_QlikView/ChartFunctions/SetAnalysis/set-modifiers-implicit-field-value-definitions.htm

topic FirstSortedValue : We have to find the tables from table1 which are not present in table 2. in App Development

FirstSortedValue : We have to find the tables from table1 which are not present in table 2.

Re: FirstSortedValue : We have to find the tables from table1 which are not present in table 2.