Hide / Show the column in a Table based on filter selection value

[varaprasad0816]

Hi,

I have a scenario in Hide / Show condition as mentioned below.

I have two columns as filters as mentioned below and created one table with 4 columns

Filters :

1. Columns

2. Use Case

Table Columns :

1. Name

2. City

3. Use Case

4. Case Load

I have written a condition in Visibility condition for 4th column (Case Load) as mentioned below based on my two filters (1. Columns ; 2. Use Case)

Visibility Condition :

if(Getfieldselection(Columns)='Treatment',1,0) OR if(Getfieldselection(Use Case)='Novartis Engagement',1,0)

The above condition is working for Columns= ' Treatment ' but not for Use Case = 'Novartis Engagement',

Could you please why the 4th column is not showing when I select 'Novartis Engagement from Use Case filter.

Please help me out on this.

Please find attached screen shot for your reference.

this is bit urgent.

Regards,

Vara'

[NitinK7]

Hi,

can you paste here some sample data

[varaprasad0816]

Hi,

Please find below sample data for your reference.

Regards,
Vara

[varaprasad0816]

Hi,

Please find below sample data for your reference.

UseCase	IMS-IDName	Country	CaseLoad
Lung Early Adopters	Jhon	US	10
Novartis Engagement	Sont	Canada	20
Lung Early Adopters	Michal	New Zealand	30
Novartis Engagement	Lalit	Australia	40
Lung Early Adopters	Maston	Germany	50
Novartis Engagement	Jackson	MVD	60
Lung Early Adopters	Nichal	France	70

Regards,

Vara

[NitinK7]

Hi,

try to write below expression in show column if

GetFieldSelections(Columns)='Treatment' or GetFieldSelections(UseCase)='Novartis Engagement'

[varaprasad0816]

Hi,

1st Scenario :

I have applied same condition in Visibility condition of the particular measure as mentioned below.

which is working fine for 1st condition (before OR), not working for second condition (after OR)

Working for : Getfieldselections(Columns)='CaseLoad - Total treated'

Not Working for :  Getfieldselections(UseCase)='Novartis Engagement'

Second Scenario :

When client select multiple field values from "Columns" field, the respective of all fields should display in the table which I took as measures or else these should be in Hide condition.

If I select single field value, display single field value in the table

If I select multiple field values, display multiple field values in the table

Or else, all these fields in Hide condition.

Could you please help me out to get these two scenarios.

Please

Regards,

Vara

[NitinK7]

can you attach your sample qvf using some dummy record 

because this expression is working for me

so need to check your qvf

[varaprasad0816]

Hi,

I can't share you the QVF file as working in remotely, don't have access to share it .

Regards,

Vara

[varaprasad0816 · Accepted solution]

Hi,

It got resolved by writing same expression in " calculate column if "

thnks,

Vara

[sunil_sawargave]

HI,

Nitink7

Its working fine for me.

Thanks & regards

Sunil Sawargave