Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Digvijay_Singh

How Set Analysis works when measure field exists in different table and Dimension value is NULL

Hi,

I am trying to understand why set analysis drops some rows when chart dimension value is null and measure field exists in different than chart dimension field.

I have attached sample app, very similar to what we have in production app. The main question is, why left chart shows count 2 against null dimension but right one shows 1 against null dimension.

I observed if I replace set analysis expression with IF statement, both chart shows 2 against null dimension value.

clipboard_image_0.png

 

@hic 

@swuehl 

@stevedark 

@rwunderlich 

@jagan 

@Gysbert_Wassenaar 

@sunny_talwar 

Any help will be highly appreciated.

Thanks,

DJ

 

 

Labels (2)
10 Replies
Ksrinivasan
Specialist
Specialist

hi,

can you send as QVW file,

K. Srinivasan

 

thi_pham
Creator III
Creator III

Interesting, I cannot understand why right chart return values like that, problem should be in the multi value of Pat ID key1 in Link_Table, I tried to make a left join between Link_Table and Patient_Table, then right chart will be the same of left one. Just for your information. Look forward to someone explain this case.

Digvijay_Singh
Author

Attached is the QVW reflecting the same issue.

Thanks for your time.

 

DJ,

Digvijay_Singh
Author

Thanks for your response.

Its really very confusing case, I cannot join link table and patient dim table but I would certainly will see how that is making difference. I have been trying to understand how 'IF' inside count in the right chart makes both chart match, so not sure if its something related to table associations? or its linked to the behavior of set analysis when fields come from different tables.

Thanks,

DJ

Ksrinivasan
Specialist
Specialist

Hi,

please refer below table and chart, it will make clear you,

clipboard_image_0.png

 K. Srinivasan.

thi_pham
Creator III
Creator III

It doesn't make the problem clearer with me. Just add 1 more dimension (_f2f_enc_ind or _addl_visit_vol_enc_ind or  _appt_complete_ind) to right chart , you will see the strange thing.

Ksrinivasan
Specialist
Specialist

Hi,

See below Table and chart, as you said dimension added,

clipboard_image_0.png

K. Srinivasan

Digvijay_Singh
Author

Thanks for your response. I know what is happening but I don't know why one null dimension row is dropped when measure field comes from other table.

 

DJ,

Digvijay_Singh
Author

Another angle of the problem is - if in the right chart I use 'IF' instead of set analysis it start matching with the left chart.( I have kept 'IF' statement commented in the right chart.)

So not sure whats the root cause behind the difference. Its certainly a combination of set analysis behavior and table association.(Not just having measure field in another table)

 

Thanks,