Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
KundanJyothsna
Contributor II
Contributor II

Show matched and unmatched records

Hi All,

can we get both matched & unmatched records for the selected month in a table where Unmatched records should appear with
values as zero or null. I have used simple field select to display current month matched data where it is showing currrent month week-over-week data.
Not sure, but can we use p() or e() in achieving it. If yes a code snippet will be a great help.mor any other method . 

 

TIA.

Labels (1)
2 Replies
Chanty4u
MVP
MVP

attaching one sample example it might help

KundanJyothsna
Contributor II
Contributor II
Author

Hi Chanty,

 

I dont have qlikview so converted it into qlik sense, but i can see nothing just loaded  but there are no vizualitions.

Can you put the expresions u have used in showing all records when any month filter is applied.

 

 

Thanks

Jyothsna Kundan