topic Re: My Pivot Table is displaying incorrect value based on my set analysis in QlikView

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

jim_chan — Thu, 04 Oct 2018 08:43:21 GMT

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

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

olivierrobin — Thu, 04 Oct 2018 08:48:49 GMT

hello

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

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

kfoudhaily — Thu, 04 Oct 2018 08:50:01 GMT

Hello, the sample you provided is empty;

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

jim_chan — Thu, 04 Oct 2018 09:09:38 GMT

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

sorry

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

olivierrobin — Thu, 04 Oct 2018 09:25:49 GMT

hello,

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

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

tresB — Thu, 04 Oct 2018 09:27:34 GMT

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)

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

jim_chan — Thu, 04 Oct 2018 09:28:05 GMT

can you show it in my sample.qvw?

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

jim_chan — Thu, 04 Oct 2018 09:28:46 GMT

ok. let me try it out bro

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

jim_chan — Thu, 04 Oct 2018 10:05:43 GMT

this works ! thanks bro!!!!!

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

jim_chan — Thu, 04 Oct 2018 10:07:02 GMT

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.

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

jim_chan — Fri, 05 Oct 2018 02:19:30 GMT

hi there,

i will create composite key, it works as well. thank you bro!

Rgds

Jim