topic Re: Condition on suppress null in QlikView

Condition on suppress null

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have 3 dimensions policy no,status,batch code in which i have to filter the data when batch code=T928 and apply suppress null on the null values but the problem is i have to show the policy no of status 'PR' in the chart where the batch code is null.

LOAD * INLINE [

Policy no, status, Batch code

123, IF, T928

234, IF, T928

456, PR

567, PR

789, IF, T928

789, IF, T903

];

I have to made this changes on a straight chart so is there any way to restrict policy no of 'PR' status even after applying Suppress null.

Re: Condition on suppress null

HirisH_V7 — Sun, 27 Nov 2016 08:45:57 GMT

Hi,

May be like this,

using calculated dimension,

=If([Batch code]='',[Policy no],[Batch code])

PFA,

Hirish

Re: Condition on suppress null

Anil_Babu_Samineni — Sun, 27 Nov 2016 08:50:48 GMT

What was expected Result?

Re: Condition on suppress null

Sun, 27 Nov 2016 09:29:44 GMT

Policy No	status	Batch code
123	IF	T928
234	IF	T928
456	PR	-
567	PR	-
789	IF	T928

after applying suppress null i want to show the policy no with status 'PR' in chart.

Re: Condition on suppress null

HirisH_V7 — Sun, 27 Nov 2016 10:19:58 GMT

May be this at your Status dimension,

=If([Batch code]='',status &'-'&[Policy no],status)

Re: Condition on suppress null

Frank_Hartmann — Sun, 27 Nov 2016 15:32:56 GMT

have a look at the attached sample.

hope this helps

Re: Condition on suppress null

tamilarasu — Sun, 27 Nov 2016 15:53:11 GMT

Hi Mohd Bilal,

Dimensions:

policy no

status

[Batch code]

Expression:

If([Batch code]='T928' OR Len(Trim([Batch code]))=0,[Batch code],0)

Hide the expression column in presentation tab and make sure suppress Zero-Values is option enabled. See attached file for better understanding.

Re: Condition on suppress null

susovan — Mon, 28 Nov 2016 05:15:17 GMT

You can also try this way,

Data:

LOAD * INLINE [

Policy no, status, Batch_code

123, IF, T928

234, IF, T928

456, PR

567, PR

789, IF, T928

789, IF, T903

]

Where not Match( Batch_code,'T903')

;

Re: Condition on suppress null

Anonymous — Mon, 28 Nov 2016 05:33:17 GMT

You can use following expression by adding calculated dimension in straight table :

=if(len([Batch code])=0,[Policy no],[Batch code])

result will be following:

Policy no	status	Batch Code
123	IF	T928
234	IF	T928
456	PR	456
567	PR	567
789	IF	T928
789	IF	T903

Thanks,