topic Re: Expession help....!!! in QlikView

Expession help....!!!

Thu, 23 Apr 2015 06:51:05 GMT

Dear All,

One of my simple expression i have used in my pivot table is shown below.

ROUND (RANGESUM (BRO_COMM,AGE_COM,+GRO_COM,-TOT_COM))

I want to hide or remove the zero values shown as a result of above expression without considering the results of the other expression.

So can you any one help me to find the effective formula instead of the above or what modification i could do.

Thanks.

Priyantha.

Re: Expession help....!!!

Thu, 23 Apr 2015 08:40:21 GMT

Please help .

Re: Expession help....!!!

amit_saini — Thu, 23 Apr 2015 08:42:28 GMT

Hi,

Checked "Suppress When Value is null"" option in dimension and Presentation tab and check.

Thanks,
AS

Re: Expession help....!!!

Thu, 23 Apr 2015 08:49:22 GMT

not working.

Re: Expession help....!!!

Thu, 23 Apr 2015 08:57:24 GMT

if(isnull(ROUND (RANGESUM (BRO_COMM,AGE_COM,+GRO_COM,-TOT_COM)))=0,ROUND (RANGESUM (BRO_COMM,AGE_COM,+GRO_COM,-TOT_COM)))

Re: Expession help....!!!

Thu, 23 Apr 2015 09:05:51 GMT

Thanks for the early reply,

But the expression does not changed the result of my expression. It means not successful for my requirement.

Priyantha.

Re: Expession help....!!!

Thu, 23 Apr 2015 09:12:39 GMT

Send me sample qvw file

Re: Expession help....!!!

Thu, 23 Apr 2015 09:25:28 GMT

BCOD	CRE_CODE	CLA_CODE	GL_CODE	REF_NO	POL_NO_2014	PREMUM	BRO_COMM	AGE_COM	GRO_COM	TOT_COM	EXCESS
BA00	1017-021	MC	70310	BA0015D0030088	BA00151D0003341	26199	0	2295	0	3146	-851
				BA0015D0030093	BA00151X0000379	12027	0	1095	0	1477	-382
				BA0015D0030094	BA00151X0000380	10896	0	989	0	1336	-347
				BA0015D0030185	BA00151D0003342	34509	0	3001	0	3001	0
				BA0015D0030216	BA00151D0003344	15199	0	1332	0	1332	0
				BA0015D0030217	BA00151D0003345	21828	0	2008	0	2008	0
				BA0015D0030218	BA00151A0001453	110255	0	10126	0	10126	0
				BA0015D0030219	BA00151D0003346	15773	0	1390	0	1390	0
				BA0015D0030250	BA00151D0003347	62368	0	5749	0	5749	0
				BA0015D0030295	BA00151D0003349	20759	0	1826	0	1826	0
BW00	1017-021	MC	70310	BW0015D0030219	BW00151D0002609	16345	0	1447	0	1447	0

Re: Expession help....!!!

Anonymous — Thu, 23 Apr 2015 09:29:00 GMT

if possible share your qvw with sample data .. so that somebody can work on it and send solution back.

Thanks

BKC

Re: Expession help....!!!

awhitfield — Thu, 23 Apr 2015 09:32:35 GMT

Hi,

have you tried clicking 'Suppress Zero Values' on the Presentation tab?

Andy

Re: Expession help....!!!

Thu, 23 Apr 2015 09:42:39 GMT

not successful,

Re: Expession help....!!!

awhitfield — Thu, 23 Apr 2015 09:49:35 GMT

You need to post an example app

Re: Expession help....!!!

ankitaag — Thu, 23 Apr 2015 10:07:30 GMT

Do you mean that if BRO_COMM=0 then the value for BA00 should not be visible? no matter AGE_COM and other columns have values?

Re: Expession help....!!!

Thu, 23 Apr 2015 10:15:03 GMT

No dear,

The outcome results of the above expression = 0 then that raw should not be shown in the pivot table, not considering the results of the other expressions.

I have opened a new discussion and posted the sample Qvw file also for your easy referance.

Priyantha.

Re: Expession help....!!!

awhitfield — Thu, 23 Apr 2015 10:16:11 GMT

If(ROUND(RANGESUM(BRO_COMM,AGE_COM,+GRO_COM,-TOT_COM))<>0,ROUND (RANGESUM (BRO_COMM,AGE_COM,+GRO_COM,-TOT_COM)),'')