Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
sachin1
Contributor II
Contributor II

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

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
Labels (3)
1 Reply
maxgro
MVP
MVP

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