Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Help Needed - How to Show conditional fields based on selections

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:

Month12346
1100100250200150
2100250300100100
350150200300250

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

Month3420
1250200125
2300100200
3200300150

I hope to be clear. Please, HELP!

Thanks!!!

1 Solution

Accepted Solutions
Highlighted
Specialist II
Specialist II

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

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

PFA

Hope this helps!

View solution in original post

15 Replies
Highlighted

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

HI

PFA

Hope it helps

Highlighted

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

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

Highlighted
Not applicable

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

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

Highlighted
Not applicable

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

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

Highlighted
Not applicable

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

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

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

Highlighted
Not applicable

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

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

Highlighted
Not applicable

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

Thanks Mayils!!!

Its correct!!!

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

Thanks a lot!

Highlighted
Not applicable

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

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

Highlighted
Not applicable

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

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.