Condition on suppress null

[#1]

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.

[HirisH_V7]

Hi,

May be like this,

using calculated dimension,

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

PFA,

Hirish

[Anil_Babu_Samineni]

What was expected Result?

[#4]

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.

[HirisH_V7]

May be this at your Status dimension,

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

[Frank_Hartmann]

have a look at the attached sample.

hope this helps

[tamilarasu]

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.

[susovan]

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')

;

[Anonymous]

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,