Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

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

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'
 
Labels (1)
1 Solution

Accepted Solutions
Highlighted
Creator II
Creator II

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

Hi,

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

 

thnks,

Vara

View solution in original post

8 Replies
Highlighted
Creator II
Creator II

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

Hi,

can you paste here some sample data

Highlighted
Creator II
Creator II

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

Hi,

Please find below sample data for your reference.

Regards,
Vara
Highlighted
Creator II
Creator II

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

Hi,

 

Please find below sample data for your reference.

UseCaseIMS-IDNameCountryCaseLoad
Lung Early AdoptersJhonUS10
Novartis EngagementSontCanada20
Lung Early AdoptersMichalNew Zealand30
Novartis EngagementLalitAustralia40
Lung Early AdoptersMastonGermany50
Novartis EngagementJacksonMVD60
Lung Early AdoptersNichalFrance

70

 

 

 

Regards,

Vara

Highlighted
Creator II
Creator II

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

Hi,

try to write below expression in show column if

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

Capture.PNG

Highlighted
Creator II
Creator II

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

Hi,

1st Scenario :

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

varaprasad0816_0-1592916035008.png

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

 

Highlighted
Creator II
Creator II

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

can you attach your sample qvf using some dummy record 

because this expression is working for me

so need to check your qvf

Highlighted
Creator II
Creator II

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

Hi,
 
I can't share you the QVF file as working in remotely, don't have access to share it .
 
Regards,
Vara
Highlighted
Creator II
Creator II

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

Hi,

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

 

thnks,

Vara

View solution in original post