topic records show no data in QlikView

records show no data

Wed, 14 Sep 2011 09:04:07 GMT

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

records show no data

rohit214 — Wed, 14 Sep 2011 09:06:54 GMT

hey gabrial

can u send me ur file plz

thanks

rohit

records show no data

Wed, 14 Sep 2011 09:20:26 GMT

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

records show no data

Fri, 16 Sep 2011 10:22:17 GMT

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.

records show no data

Anonymous — Fri, 16 Sep 2011 10:41:30 GMT

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.

records show no data

Fri, 16 Sep 2011 10:46:10 GMT

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