Number of columns show with conditional display

[#1]

Hello,

I have a tab with a straight table where I put a number of conditional dimensions and expressions, that users can select to create ad-hoc reports.

But once they select more than 6 columns, the table does not display anything anymore.

I know I read a solution about this problem here a few months ago, but I can't remember what it was, and I was unable to find the thread. 😕

Thank you in advance.

[Gysbert_Wassenaar]

Can you post a small example qlikview document that demonstrates the problem?

[#3]

Sorry, it took me a few minutes to create a test qlikview document.

Here's a fairly simple example. I already selected six dimensions, but if I select a seventh one (in this case Product code), then they all disappear and I'm left with only the values in my table.

I remember the solution was simple, but unfortunately, I can't remember what it was. 😕

[Gysbert_Wassenaar · Accepted solution]

The getfieldselections function is messing things up because it has a default number of results it will show as list of values. If everything is selected it will return 'ALL'. Instead use expressions like this one: max(Match(Dimension,'Customer Code'))

Or go a step further and implement the technique outlined in this document: Customisable Straight (and Pivot) Tables - more food for thought

[ThornOfCrowns]

Hi, when you select all the dimensions, the Current Selections turn to ALL, which screws up your index(GetFieldSelections(Dimension),'Customer Code')>0 etc.

Add a current Selections box to your tab to see it in action.

NINJA'D by gwassenaar !!!!

[derekjones]

Hi there.

I personally use the SubStringCount(Concat(Dimension, '|'), '<Dimension Name>') to show dimensions, this way there is no issue. I've attached an example where I've replaced your conditional expressions using this.

Hope this helps

Derek

[Gysbert_Wassenaar]

SubstringCount has its own issue. Two dimensions: 'Product' and 'Product Category'. Both will show when you select 'Product' in the dimension listbox if you use substringcount like your example does.

[derekjones]

Yes very true Gysbert, I forgot about that.

[Kushal_Chawda]

Hi,

Use wildmatch with Concat ,, It works for me

See the attached

[#10]

Thanks! Adding the current selections box made me understood why my function was screwed up.