Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Hiding a column if condition occurs on Straight table


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.

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Re: Re: Hiding a column if condition occurs on Straight table

Try this. This sounds like it solves your problem.

View solution in original post

11 Replies
MVP & Luminary
MVP & Luminary

Re: Hiding a column if condition occurs on Straight table

Can you post an example document that demonstrates the problem?


talk is cheap, supply exceeds demand
Not applicable

Re: Hiding a column if condition occurs on Straight table

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.

Not applicable

Re: Hiding a column if condition occurs on Straight table

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.

Not applicable

Re: Hiding a column if condition occurs on Straight table

Hi Nikos,

Tried that infact hides other dimensions in the chart.

Not applicable

Re: Hiding a column if condition occurs on Straight table

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.

Not applicable

Re: Hiding a column if condition occurs on Straight table

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.

Not applicable

Re: Hiding a column if condition occurs on Straight table

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.

Not applicable

Re: Re: Hiding a column if condition occurs on Straight table

Try this. This sounds like it solves your problem.

View solution in original post

Not applicable

Re: Hiding a column if condition occurs on Straight table

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..:)