Discussion Board for collaboration related to QlikView App Development.
Hi to All!
My problem its that i have more than 130 columns and i need to show some columns based on a selection of an specific field
I have 130 columns with datas and other columns. Lets suposse that i have to Show the Month on rows and 130 columns on a table or pivot table.
As i have so many columns i have a separated table with: 130 rows from 1 to 130.
So, on a filter have the 130 values on the separated table.
So, i need to filter on this table those values that i wanna to see on Pivot chart. Something like that:
If i select values 1,2,3,4 and 6, i have to get the follow result:
But, if i select the values 3,4,20, i have to show:
I hope to be clear. Please, HELP!
You may check another similar discussion I participated a few time ago:
This time your metrics are in columns, but you will find there some useful info.
Please see Mayils example called check.qvw.
Please note the conditions for the dimensions
If you visit the Presentation sheet, and select Hide Column for the only expression, you will only see the selected columns...
If you add 'or GetSelectedCount(FieldSelection) = 0' (without the ' ') to every condition for every dimension, you should be on track.
Hi!!! Im sorry to say that the answer of Mayil its a good aproach, but not the correct answer.
Why? Because if you have the folters between 1 to 130, and you select 1, you will see the column 1. But, if you select 11, or 21 or any other number with 1... you will see the 1 too.
This is not correct and we cannot solve the question yet.
Im sorry... Any other ideas?
Thanks Hans for your answer... Good one to show every fields with no selections.