topic Re: how do i not display null data in a table in Connectivity & Data Prep

how do i not display null data in a table

Fri, 08 Jan 2016 19:02:15 GMT

im in qlik sense cloud

i am showing data in a table from upload xls files.

i have null rows showing and do not want to show rows with no values

i have unchecked under Data Handling the "SHow zero values" check box.

sinanozdemir — Fri, 08 Jan 2016 21:00:03 GMT

In your expression, you could do something like this:

Sum({<Company = {"*"}>}Amount)

* would sum everything, but NULL values.

reddy-s — Fri, 08 Jan 2016 22:52:41 GMT

Hi Michael,

There is an other checkbox under the dimension properties which will restrict the null Values. Its worth giving a try.

Thanks and Regards,

Sangram Reddy,