topic Show if Column problem in App Development

Show if Column problem

w0jt4z — Wed, 10 Jun 2020 08:14:42 GMT

Hi Guys, I tried to pin it to another post, but i hadn't answer. I have a little problem.

I created Dimension Table. Looks like:
Dimensions:
CrossTable(DimensionType,DimensionValue)
Load * Inline [
DimensionIndex, DimensionName, DimensionCode
1, Imię i nazwisko, PassengerName
2, Numer biletu, TicketNumber

This table I have on my filter pane. In my table every column has function in "Show column if" section:
(concat(DimensionIndex=1)) AND GetSelectedCount(DimensionValue)>0. It works, but only with 14 any dimensions. When I select 15 Dimension it shows all of columns. Anybody knows why?

Re: Show if Column problem

lironbaram — Wed, 10 Jun 2020 13:22:11 GMT

can you share an app with sample data
it's hard to understand the issue from your description

Re: Show if Column problem

w0jt4z — Mon, 15 Jun 2020 10:55:16 GMT

Of course. I tried to duplicate my problem in the test app, but here looks it's ok. Maybe it is problem with many Dimensions?
I attach my app and simplified data model.
I have data, i have attributes and "dimensions". Dimensions is for choosing which column should be on the table. What could I do wrong? The important thing is never mind which column I select, it is always >15 then show all columns.

Re: Show if Column problem

lironbaram — Mon, 15 Jun 2020 12:34:11 GMT

if you use this expression :

=if(index('|' & concat(distinct DimensionIndex,'|') & '|','|2|')>0 AND GetSelectedCount(DimensionValue)>0,1,0)

it's works for any number of dimensions

Re: Show if Column problem

w0jt4z — Tue, 16 Jun 2020 07:29:01 GMT

Thank You for solution, I'll try it, but I don't fully understand it. Why should I use '|' in my expression?
And I understand, "& '|','|2|')>0 " - the number 2 is number of my index?

Re: Show if Column problem

lironbaram — Tue, 16 Jun 2020 13:10:35 GMT

the pipe symbol is for that i'll know the separator

i look for '|2|' to be sure its a the right value , if i looked for 2 than if you had dimension 12 or 20 dimension 2 will also appear

Re: Show if Column problem

w0jt4z — Wed, 17 Jun 2020 10:50:46 GMT

I didn't know that, thank You very much for Your help! 🙂

Best Regards,
Wojtek