topic Re: Help Needed - How to Show conditional fields based on selections in QlikView

Help Needed - How to Show conditional fields based on selections

Tue, 12 Nov 2013 19:19:36 GMT

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

Re: Help Needed - How to Show conditional fields based on selections

MayilVahanan — Tue, 12 Nov 2013 19:37:39 GMT

PFA

Hope it helps

Re: Help Needed - How to Show conditional fields based on selections

CELAMBARASAN — Tue, 12 Nov 2013 19:38:46 GMT

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

Re: Help Needed - How to Show conditional fields based on selections

Tue, 12 Nov 2013 20:14:07 GMT

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

Re: Help Needed - How to Show conditional fields based on selections

Wed, 13 Nov 2013 11:17:43 GMT

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

Re: Help Needed - How to Show conditional fields based on selections

Wed, 13 Nov 2013 11:18:32 GMT

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

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

Re: Help Needed - How to Show conditional fields based on selections

Wed, 13 Nov 2013 11:34:22 GMT

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

Re: Help Needed - How to Show conditional fields based on selections

Wed, 13 Nov 2013 11:49:38 GMT

Thanks Mayils!!!

Its correct!!!

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

Thanks a lot!

Re: Help Needed - How to Show conditional fields based on selections

Wed, 13 Nov 2013 11:56:59 GMT

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

Re: Help Needed - How to Show conditional fields based on selections

Mon, 18 Nov 2013 18:16:39 GMT

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.

Re: Help Needed - How to Show conditional fields based on selections

jerem1234 — Mon, 18 Nov 2013 18:32:12 GMT

Maybe add | at the end and beginning of the selection list of what Mayil did, that way it can sort of denote an "end" and "beginning" character then search for '|#|'

Try this formula for the dimensions, for example 1:

Index('|' & GetFieldSelections(FieldSelection ,'|',100)&'|','|1|')

Hope this helps!

Made an edit: Need a beginning character as well.

Re: Help Needed - How to Show conditional fields based on selections

Mon, 18 Nov 2013 20:02:43 GMT

Im sorry but im trying all sugestions but, nothing seems to work fine.

Here its the example of my file.

When i select numbers between 1 to 7, works fine.

But, if i select 29, por example, i see incorrect columns...

Re: Help Needed - How to Show conditional fields based on selections

jerem1234 — Mon, 18 Nov 2013 20:08:34 GMT

I edited my last reply to have a beginning character as well as the ending, I think that should solve it.

Did you try it that way?

Re: Re: Help Needed - How to Show conditional fields based on selections

jerem1234 — Mon, 18 Nov 2013 20:17:26 GMT

I did from 1-30, and it seems to be working with the new beginning character.

PFA

Hope this helps!

Re: Help Needed - How to Show conditional fields based on selections

Mon, 18 Nov 2013 20:37:10 GMT

Thanks Jerem!!! Correct!!!

Thanks a Lot!!!!

Re: Help Needed - How to Show conditional fields based on selections

Tue, 19 Nov 2013 19:02:57 GMT

Finally, the correct formula was:

Thanks to All for Help Me!!!!!

Regards!