Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Return data with no primary key

i have an example here i just like to get the accounts with no ID but contains data.

table1

AccountIDAccountNameSalesMonth
101James100Dec
102Harden250Dec
--350Dec
104Durant200Dec

What's the best way to show the blank data row.

5 Replies
sreenivas
Creator III
Creator III

Hi

Do you need to eliminate those Values then use inner or left join

Not applicable
Author

No sir, i just need to display the data without accountID.

sreenivas
Creator III
Creator III

If it is a straight Table there will be a option Properties-->dimensions Tab--> check the Supress When Value is Null

Not applicable
Author

I need to display

- - 350 dec

Miguel_Angel_Baeyens

Hi,

I'd use something like the following to exclude all fields that have a non blank / null value:

Only({< AccountID -= {"*"} >} Sales)

or

Only({1 - < AccountID = P(AccountID) >} Sales)

And the same set analysis with the Month field.

Hope that helps.

Miguel