topic Re: avoid columns in QlikView

avoid columns

priyarane — Wed, 25 Nov 2020 16:16:04 GMT

Hi Community,

I am using Pivot table like below.

I wanted to avoid columns if no data, right now no data available in child8 to child13 but in future we will get. How can I achieve it

- Priya

Re: avoid columns

sunny_talwar — Fri, 17 Jun 2016 12:10:37 GMT

I don't think this would be possible in pivot table. You can try this with straight table with multiple expressions with show/hide conditions

Re: avoid columns

swuehl — Fri, 17 Jun 2016 12:11:03 GMT

What is your expression?

Try something like

=If( Len(Trim( YourExpression)) , YourExpression)

edit:

Or try conditional dimensions, for your child dimensions, so you would need to create a condition that checks if there are any child values available:

For example for Child_8 dimension:

=Count( Child_8 )

=Count( If(Len(Trim(Child_8)), Child_8))

Re: avoid columns

priyarane — Fri, 17 Jun 2016 12:18:29 GMT

it is not working out

Re: avoid columns

sunny_talwar — Fri, 17 Jun 2016 12:20:55 GMT

Would you be able to share a sample?

Re: avoid columns

swuehl — Fri, 17 Jun 2016 17:05:22 GMT

Seems to work for me, using my sample data and the dimension conditions:

LOAD * INLINE [

ID,Child1,Child2, Child3

1,C1, C2,C3

2,C1,C2,

3,C1,,

];