My Pivot Table is displaying incorrect value based on my set analysis

[jim_chan]

Hi guys,

I have created a sample qvw file with inline data as well. Basically I have 2 files. and need 2 expression.

1st expresssion is ok = to show how many time this record ID has visited the outlet. - data is from table transaction

2nd expression in the pivot is not correct = to show the the record ID CONFIRM purchase at which outlet. - data is from table confirmation, table 2.

my expectation result is , it should so 0 value on the blank outlet_visited row. because based on the confirmation data table 2, shows that record ID 12345, confirm purchased at ABC.

Please help guys....!

[olivierrobin]

hello

your qvw doesn't contain anything ........

[kfoudhaily]

Hello, the sample you provided is empty;

[jim_chan]

my apology, this is the sample file. not empty anymore.

sorry

[olivierrobin]

hello,

why don't you link your 2 tables on the key record_id + outlet_purchased ?

[tresesco]

Your outlet has value non-null  invisible character that is causing the issue. If you want to exclude that, try expression like:

=count( {$< outlet_purchased={"=Len(Trim(outlet_purchased))>0"},confirm_status = {'CONFIRM'}>}timestamp1)

[jim_chan]

can you show it in my sample.qvw?

[jim_chan]

ok. let me try it out bro

[jim_chan]

this works ! thanks bro!!!!!

[jim_chan]

bro, i will try your suggestions tomorrow. i got info from my customer, for the real scenario, the fields can be link, i mean can create a link key.