Hiding a column if condition occurs on Straight table

[#1]

Hi,

I have a Straight table with multiple fields/columns.I have a requirement to hide a column Post_Address when Post_Address=NA for a particular ID

and another column Child_Num when Child_Num=0 for list of ID's.

already tried with the below

if(Post_Address<>'NA',Post_Address)

SubStringCount(Concat(ID,'|'),1002)>>0

If(IsNull(POSTAL_CD),0,1)         ---->This is not applicable

Please suggest if anyone have any idea?

Thanks in advance.

[Gysbert_Wassenaar]

Can you post an example document that demonstrates the problem?

[#3]

I can't post the document Gysbert.

I have a straight table which is having 6 fields in dimension. ID,Post_Address,Child_Num,Parent_Num and so on.

For a particular ID, Post_Address value=NA likewise Child_Num=0 for list of ID's also.

My requirement is For those ID's having Post_Address=NA, we should hide the Post_Address column.but it should display for other ID's same for Child_Num also.

Thanks.

[#4]

Hi gtripathy,

You can do that by making every dimension that complies with that specific condition to null and then suppress null values.

For example, if(Post_Address<>'NA',Post_Address,null()) and extend that for every expression.

Regards.

[#5]

Hi Nikos,

Tried that infact hides other dimensions in the chart.

[#6]

Hi gtripathy,

I dont think there is a way to hide only a specific colunm on a chart as per your requirement.

You can try calculated dimension but it will still have the same result.

Regards.

[#7]

If I'm understanding you correctly, you want to hide the column Post_Address only for rows in a straight table that have a value of "N/A"?

Showing blank doesnt meet your criteria, correct?

Does this table show several IDs or only for looking at one particular ID?

In other words, could the Post_Address column have "N/A" values and non-"N/A" values? If it shows both types simultaneously, then you cannot hide the column for just specific rows. You will either need to blank the value for rows meeting your "N/A" criteria or hide the column for all rows.

[#8]

Hi Matthew Riedl,

I want to hide the column Post_Address column if it is equal to NA.This straight table actually shows ID's based on the SalesForce.

What it mean is e.g- For Salesforce AI, There ll be a Detail straight table shows ID,Post_Address,Child_Num and all based on that SalesForce.

So Suppose for SalesForce AG, straight table shows  all Post_Address,Child_Num,Parent_Num for ID 1005,1006.

If the Post_Address values are NA for both the ID's,i want to hide the column.

Thanks.

[#9 · Accepted solution]

Try this. This sounds like it solves your problem.

[#10]

Thanks Matthew.It worked.But if i have two fields to hide like NA and 0.

if(only(Post_Address)='NA' or 0,0,1) i tried this but it didn't work out.

Thanks a lot again..:)