topic Re: Condition to show a field in QlikView

Condition to show a field

Thu, 31 Jul 2014 14:51:21 GMT

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

Re: Condition to show a field

simenkg — Thu, 31 Jul 2014 14:52:58 GMT

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

Re: Condition to show a field

avinashelite — Thu, 31 Jul 2014 14:53:50 GMT

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

Re: Condition to show a field

Thu, 31 Jul 2014 15:07:06 GMT

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?

Re: Condition to show a field

simenkg — Thu, 31 Jul 2014 15:13:21 GMT

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.

Re: Condition to show a field

Thu, 31 Jul 2014 15:37:31 GMT

Perfect! Thank you

Re: Condition to show a field

Thu, 31 Jul 2014 15:42:46 GMT

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

Re: Condition to show a field

simenkg — Thu, 31 Jul 2014 15:44:31 GMT

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

Re: Condition to show a field

Thu, 31 Jul 2014 15:53:52 GMT

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

Re: Condition to show a field

simenkg — Thu, 31 Jul 2014 15:56:51 GMT

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

Re: Condition to show a field

Thu, 31 Jul 2014 16:06:04 GMT

I changed it to the name of the field from the list box.. and it shows up regardless of whether you choose it or not.

Re: Condition to show a field

simenkg — Thu, 31 Jul 2014 16:52:11 GMT

I've seen this before, but can't remember the exact reason.

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