Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2017-02-13 09:04 AM

Why do I have a null displayed dimension in chart with SA?

I've created a simple stright table with 2 dimensions (my actual one had more, but result was the same for other than one dim) and one expression with set analysis. The qvw is attached. I want to have CID, NUM and minimum pdate displayed for the records with NULL fdate. But for some reason my chart shows me NUM field with NULL (displayed as -) for CID = 1. Why? How can I (if any way) avoid it? Thanks!

dt.qvw
903 Views
0 Likes
11 Replies
Not applicable
‎2017-02-14 02:32 AM
Author

In response to Anonymous

But why then I had NULL in NUM when tried without aggr? And why this was only for the first row (for the CID that had values sorted out)? I definitely can't understand the expression building logic in that.

127 Views
0 Likes
Anonymous
Not applicable
‎2017-02-14 07:40 AM
Author

In response to

From what i have tested the issue is that you have the tables linked.

If you are going to do a left join with the second table, and keep only one table, the function you have wrote is correct. It seems that set analysis is not working properly for linked table, only for one table. Also, you have to select the null values, which also is special case.

Best, when Selecting Nulls better associate a value to the NULL.

Best regards,

Cosmina

127 Views
0 Likes