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: 
Not applicable

records show no data

Hi all

I have a few tables (pivoting and simple) in showing the client and family, but when I selected the month in which no sale to a customer or a family disappear records. How could I do to not disappear?

Thanks and best regards

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Did you try the "Show all values" setting on your dimension tab?

Or the the "Supress Zero-values" setting on the Presentation tab?

Maybe one of those settings gives you the result you need.

View solution in original post

5 Replies
rohit214
Creator III
Creator III

hey gabrial

can u send me ur file plz

thanks

rohit

Not applicable
Author

I'm sorry, too many confidential data on the application

Not applicable
Author

i Don't knw if i understood ur problem properly or not. but u can try this.

Add an expression : 1

Then u vil be able to see all the records.

or scramble ur cofidential field and then upload ur file.

May be then v can help.

Anonymous
Not applicable
Author

Did you try the "Show all values" setting on your dimension tab?

Or the the "Supress Zero-values" setting on the Presentation tab?

Maybe one of those settings gives you the result you need.

Not applicable
Author

Thanks for your reply Erika, but I've got, properties, dimension, check box to display allvalues. The only flaw is that in a pivot table all values ​​are 0 sales to the nest in a null field(-) rather than in the corresponding family.

I tried your solution, add a new expression in the editor type 1, but does not work.

regards