topic Re: how to hide something on a table in QlikView

how to hide something on a table

Anonymous — Tue, 27 Dec 2016 16:04:50 GMT

hi all

not sure if this is possible be see below..

in the fabric group column..

on the bottom there are blanks.. or nulls..

how do I not load that in the table without using the suppress null function in the table?

thanks

Re: how to hide something on a table

Tue, 27 Dec 2016 16:32:33 GMT

The one option is to remove the Partial sum option in the properties tab. But it lost total on the body class as well. Do you want show the null value in the Fabric Group column ?

Re: how to hide something on a table

MK_QSL — Tue, 27 Dec 2016 16:42:15 GMT

Your Expression......

SUM({<Fabric = {'*'}>}Sales)

Change your expression accordingly..

Re: how to hide something on a table

Anonymous — Tue, 27 Dec 2016 17:22:51 GMT

hi..

that's exactly it.. I do not want null to show up on the fabric group column..

I thought I could do that somehow in the dimension field with a if statement but not sure...

if(fabricgroup =' ' then ??

something like that

thanks

Re: how to hide something on a table

Anonymous — Tue, 27 Dec 2016 17:24:19 GMT

hi manish

not sure what this will do..

but the aggr and sums work..

I just like if fabric group = null hide somehow

thanks

Re: how to hide something on a table

MK_QSL — Tue, 27 Dec 2016 18:05:03 GMT

provide sample data.. will do it for you..

Re: how to hide something on a table

el_aprendiz111 — Tue, 27 Dec 2016 19:18:23 GMT

Hi,

SUM({$<FABRIC={'*'} - {' '}>}SALES)

Re: how to hide something on a table

HirisH_V7 — Tue, 27 Dec 2016 19:19:58 GMT

Hi,

Include this in all of your set expressions,

=sum({$<[Fabric Group]-={"=len(trim([Fabric Group]))=0"}>} [Total Units])

HTH,

Hirish

Re: how to hide something on a table

Tue, 27 Dec 2016 20:34:48 GMT

Fabric Group and Body Class both are coming from same table or different tables ? The issue here you may dont have proper fabric group for your Body class and Fact value. So it showing null value in the fabric group. If you don't want load null Fabric group values, discard those data across all the tables in the script level.

Re: how to hide something on a table

Anonymous — Tue, 27 Dec 2016 20:47:07 GMT

hi srikanth...

yes there is bad data that's why this is showing up the way it is..

the thing is I can remove it from the load.. so it doesn't even load in but it helps me catches missing data or badly entered stuff.. so I can go back and correct.

that's why im wondering if I can use an expression to get rid of it on the table itself.

thanks

Re: how to hide something on a table

mayankraoka — Thu, 29 Dec 2016 06:55:12 GMT

Hi Jackie,

Did you get the solution for this.

If yes please share.I am also facing the same issue.

Regards,

Mayank

Re: how to hide something on a table

Anil_Babu_Samineni — Thu, 29 Dec 2016 07:04:26 GMT

Why not suppress simply, Is there any restriction to do that. Have you seen Hirish Reply. It should work check and confirm the same. Or you may can share application so that we can help you on that

Re: how to hide something on a table

Anonymous — Thu, 29 Dec 2016 07:36:39 GMT

Hi,

In Chart Properties -> Dimension -> Select "fabricgroup" field then Check the option "Suppress When Value is Null"

Re: how to hide something on a table

Anonymous — Wed, 04 Jan 2017 20:25:27 GMT

hi anil

payal is correct.

I misread it and kept going to the expression section and not the dimension on the dimension..

I totally missed that.

thanks all

Re: how to hide something on a table

Anonymous — Wed, 04 Jan 2017 20:26:03 GMT

misread your thing.

went to expressions instead of dimension.. under properties

this works like magic

thanks