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

[sachin1]

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

[maxgro]

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/Se...