Help Needed - How to Show conditional fields based on selections

[#1]

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

For instance

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:

Month	1	2	3	4	6
1	100	100	250	200	150
2	100	250	300	100	100
3	50	150	200	300	250

But, if i select the values 3,4,20, i have to show:

Month	3	4	20
1	250	200	125
2	300	100	200
3	200	300	150

I hope to be clear. Please, HELP!

Thanks!!!

[MayilVahanan]

HI

PFA

Hope it helps

[CELAMBARASAN]

You could use Condition dimension if your are using Qlikview 11.

[#4]

German,

You may check another similar discussion I participated a few time ago:

http://community.qlik.com/thread/94768

This time your metrics are in columns, but you will find there some useful info.

Fabrice

[#5]

Yes Celambarasan...  but the questions its How...

[#6]

Hi Aunez... I dont see the way to do it in the post that you mentionit...

Im Sorry... Maybe i didnt explain correctly...

[#7]

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

[#8]

Thanks Mayils!!!

Its correct!!!

I hav only to find the way to make all fields appears when nothing its selected...

Thanks a lot!

[#9]

If you add 'or GetSelectedCount(FieldSelection) = 0'  (without the ' ') to every condition for every dimension, you should be on track.

[#10]

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.