Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
sampada0810
Creator
Creator

Getting missing values in text box

Hi All,

I have a scenario where in I have 2 same columns(ProductKey) in 2 different source tables: say A.ProductKey coming from source table A and B.ProductKey coming from source Table B.

I want to get the mismatching values of the 2 columns in a text box so that I can pull them and show the values in the NPrinting report saying : 'xxx'are the values from Source Table B which are not Present in Source Table A.

How will I handle this  (preferably at the front end) in Qlik Sense ??

Thanks,

Sampada

3 Replies
rubenmarin

Hi, if there is a field that always has a value you can use it to count values in that table, ie:
Count(Distinct {<FieldTable1={"*"}>} ProductKey)
Count(Distinct {<FieldTable2={"*"}>} ProductKey)
sampada0810
Creator
Creator
Author

I want to have the values in the text, and not the count of the missing records.
I am able to get the count, but finding difficulty in getting the record values.
rubenmarin

Maybe with:
Concat(Distinct {<FieldTable1={"*"}>-<FieldTable2={"*"}>} ProductKey, ', ')