Condition to show a field

[#1]

What is a condition I can use to show a field in a pivot table from a list box created by an inline load?

[simenkg · Accepted solution]

substringcount(Concat(InlineField,'|'),DimensionName)=1

Example:

%Dimensions:
Load * inline [

%Dimension

Year,

Month

];

the condition for showing dimension Year then becomes:

Substringcount(Concat(%Dimension,'|'),'Year')=1

[avinashelite]

Hi,

Paste getselectedcount(filendname)>0 this in below suggested boxes

If your using it as dimension then below u will see Enable conditional write the condition here,

if your using it in expression use conditional it will do the job

[#4]

I'm having a weird issue. So I have fields like these in my inloads:

Source1

Source2

Source3

Source1_A

Source1_B

Source1_C

Source2_A

Source2_B

Source2_C

and so on.... the condition above works BUT if I select both Source1 and Source1_A, it will only show Source1_A. Same with the others. If I select all Source1, Source1_A, Source1_B, and Source1_C, it will show me everything except for Source1.

What is the issue here?

[simenkg]

This is because the substring "Source1" exists in Source1_A, Source1_B but not the other way around.

change your inline table to

%dimensions:

Load * inline [

%Dimension, %DimensionID

Source1, 01

Source2, 02

Source3, 03

Source1_A, 04

Source1_B, 05

Source1_C, 06

Source2_A, 07

Source2_B, 08

Source2_C, 09

];

and so on.

Then the condition becomes:

Substringcount(Concat(%DimensionID,'|'),'01')=1

but you still keep the %Dimension in the list box.

[#6]

Perfect! Thank you

[#7]

Is there any way that whenever I don't have any of them selected, that none of them show?

Right now, if I select one, it will only show that but if I have none selected, it will show all

[simenkg]

Yes.
Add:
Substringcount(Concat(%DimensionID,'|'),'01')=1 and GetSelectedCount(%Dimension)>0

[#9]

That doesn't seem to work... it doesn't show up at all...

[simenkg]

Have you changed "%Dimension" to the name of the Field you select in the list box?