topic Hoe to hide Row with perticular value in QlikView

Hoe to hide Row with perticular value

Tue, 28 Dec 2010 10:36:39 GMT

I want to know how to hide perticular coloumn in pivot table containing value as null.

In my pivot table I'm calculating some expression after calculation row gets displayed at subtotal coloumn which wont contain any field name (only null symbol) but values exists there .I want to remove perticular coloumn

Hoe to hide Row with perticular value

Tue, 28 Dec 2010 12:03:33 GMT

hi Gokul,

Chek this one if i am right,

Pivot table -> properties->Presentation tab -> Suppress Missing which is in left bottom

check that box

Regards,

prabhu

Hoe to hide Row with perticular value

Tue, 28 Dec 2010 12:48:52 GMT

Thanks for reply Prabhu ,

But I had already tried this option but I'm not able to get removed perticular row..

Onething I observed that whenever I use subtotal on Top /Bottom from presentation tab row changes position also accordinfg to selection .

I had already tried this for partial sums also...but I'm not able to get proper solution .

Hoe to hide Row with perticular value

syed_muzammil — Tue, 28 Dec 2010 13:16:54 GMT

Hi,

Did you try Suppress when Value is Null in Properties-->Dimension Tab?

Hoe to hide Row with perticular value

Tue, 28 Dec 2010 13:27:57 GMT

I had tried supress null value also .But It affects my calculations

for example :I want those null values also to calculate same expression but I dont want to display them in table .By using supress null which ommites those values for calculation also.So that should not be happen .

If anybody having Idea to hide perticular row i.e. color of text and background same so that row will be displayed but user not able to see those values

Please reply

Hoe to hide Row with perticular value

Tue, 28 Dec 2010 14:54:03 GMT

Hi Gokulthube,

If you are referring to the expression column.Then the same can be done through Visual cues tab based on the specific condtion.

Hoe to hide Row with perticular value

Wed, 29 Dec 2010 06:58:52 GMT

Yes I'm using expression but still not able hide perticular row..

I had tried to hide with visual cues also please suggest me way so that I'll be able to hide perticular row .

Hoe to hide Row with perticular value

Wed, 29 Dec 2010 13:37:45 GMT

Hi GokulThube,

Will you be able to attach the QVW file ?

Hoe to hide Row with perticular value

Thu, 30 Dec 2010 07:01:53 GMT

I'm Sending application for your understanding please reffer attached application .

Hoe to hide Row with perticular value

Thu, 30 Dec 2010 07:04:21 GMT

Hi ,

Attached file contains problem statement and various approaches I had tried .

Hoe to hide Row with perticular value

Thu, 30 Dec 2010 09:51:31 GMT

Hi,

Attached the Screenshot for your reference. As per the excelsheet if you want to hide the row that was showing null you can enable the checkbox Supress when value is Null for the dimension =if([Support Month]<>'*',[Support Month]) .

Hoe to hide Row with perticular value

Thu, 30 Dec 2010 11:10:48 GMT

Hi ,

Thanks for reply but this option I had already checked .In this which affects on calculations

see first value it changes fro 16.67 to 18.18.

So this is not fesible solution.

Hoe to hide Row with perticular value

Thu, 30 Dec 2010 12:53:12 GMT

Hi Gokulthube,

Yes the values are getting changed . Not only 16.67 to 18.18.

Since when you have transposed (Soldmonth) the rows to columns. So many values has been changed. If you can share the buisness logic may be if not me some one will be able to help to achive the same.