topic Re: Conditionally show the column based on two values in QlikView

Conditionally show the column based on two values

Wed, 25 Nov 2020 16:16:04 GMT

I created a straight table in that i have few coulumns,want to disaply a coluimn based on another column two values

I have done getfieldselections(COUNTRY)=INDIA ,Its working but i want to give one more value

like getfieldselections(COUNTRY)=INDIA and getfieldselections(COUNTRY)=US

its not working for me it is working for only one value.

Please suggest for this

Re: Conditionally show the column based on two values

vikasmahajan — Thu, 10 Mar 2016 10:01:42 GMT

try with this =If(Match(GetFieldSelections(COUNTRY),'INDIA','US','JAPAN'), COUNTRY)

Vikas

Re: Conditionally show the column based on two values

Kushal_Chawda — Thu, 10 Mar 2016 10:04:14 GMT

try

if(match(Country,'India','US'),1,0)

if( Country ='India' and Country='US',1,0)

Re: Conditionally show the column based on two values

sunny_talwar — Thu, 10 Mar 2016 10:06:01 GMT

Not sure if this is truly and requirement where you would make multiple selections in the COUNTRY filter or if this is just an or requirement.

If its INDIA and US, try like this:

SubStringCount(Concat(DISTINCT COUNTRY, '|'), 'INDIA') = 1 and SubStringCount(Concat(DISTINCT COUNTRY, '|'), 'US') = 1

If its INDIA or US

SubStringCount(Concat(DISTINCT COUNTRY, '|'), 'INDIA') = 1 or SubStringCount(Concat(DISTINCT COUNTRY, '|'), 'US') = 1

Re: Conditionally show the column based on two values

Anonymous — Thu, 10 Mar 2016 10:08:37 GMT

If it is your calculated dimension then try like this?

=IF(Country='INDIA' or Country='USA', Country)

If it is your expression then try like this?

=sum({<Country={'INDIA','USA'}>} Sales)

Re: Conditionally show the column based on two values

Thu, 10 Mar 2016 10:55:42 GMT

Hi Kush,

Its working for India or US and

i need third scenario like INDIA and US.

Means 1.India

2.US

3.INDIA and US

for third scenario waht i need to do?

Please do the needful

Re: Conditionally show the column based on two values

Thu, 10 Mar 2016 10:56:16 GMT

HI Sunny

Its working for India or US and

i need third scenario like INDIA and US.

Means 1.India

2.US

3.INDIA and US

for third scenario waht i need to do?

Please do the needful

Re: Conditionally show the column based on two values

Thu, 10 Mar 2016 10:57:26 GMT

Its working for India or US and

i need third scenario like INDIA and US.

Means 1.India

2.US

3.INDIA and US

for third scenario waht i need to do?

Please do the needful

Re: Conditionally show the column based on two values

sunny_talwar — Thu, 10 Mar 2016 11:17:11 GMT

Which of the two expression worked?

Re: Conditionally show the column based on two values

Thu, 10 Mar 2016 11:17:59 GMT

if(match(Country,'India','US'),1,0)

Re: Conditionally show the column based on two values

Thu, 10 Mar 2016 12:53:29 GMT

Its working for India or US and

i need third scenario like INDIA and US.

Means 1.India

2.US

3.INDIA and US

for third scenario waht i need to do?

Please do the needful

Re: Conditionally show the column based on two values

sunny_talwar — Thu, 10 Mar 2016 13:23:11 GMT

Are you using this in the script?

Re: Conditionally show the column based on two values

Thu, 10 Mar 2016 15:02:07 GMT

Hi Thiru,

Try the below code n c if its working...

In the below example put your column name and modify as per your requirement

=if(SubField(GetFieldSelections(month_name),',',1)='Feb 2012' and right(GetFieldSelections(month_name),8)='Mar 2012' ,1,0)

First select two values from a Country column and then take a text box and type

=GetFieldSelections(Country)..then you can c how your value is coming like in case of below example its coming like

Feb 2012, Mar 2012 for GetFieldSelections(month_name)...

So in your case if value is coming as : INDIA, US for GetFieldSelections(Country) then try below in your conditional box of expression:

=if(SubField(GetFieldSelections(Country),',',1)='INDIA' and right(GetFieldSelections(Country),2)='US' ,1,0)

Thanks,

Itishree

Re: Conditionally show the column based on two values

Wed, 04 May 2016 12:51:43 GMT

please give the solution for this scenario

i want to show conditional visibility in state column based on year column values

1.1999

2.2000

3.1999 and 2000

it is working for 1999 or 2000 not for both

year=1999 or year=2000 or(year=1999 and year =2000),but it is not working''

cab you please do the needful

Thiru

Re: Conditionally show the column based on two values

Wed, 04 May 2016 12:51:53 GMT

please give the solution for this scenario

i want to show conditional visibility in state column based on year column values

1.1999

2.2000

3.1999 and 2000

it is working for 1999 or 2000 not for both

year=1999 or year=2000 or(year=1999 and year =2000),but it is not working''

cab you please do the needful

Re: Conditionally show the column based on two values

Thu, 05 May 2016 14:26:04 GMT

Hi Thiru,

I tried with a simple example like below and it is working fine.

in script:

Load * Inline

[CatID, Category ,state,year,value

0,Regular ,A,1999,20

1,Occasional ,B,2000,30

2,Permanent,C,2016,40];

Front end:

Took a straight table with CatID, Category ,state,year as dim and Value as expression.

Then wrote the below expression in the conditional box of state dim.

if(SubField(GetFieldSelections(year),',',1)='1999' or right(GetFieldSelections(year),4)='2000' or (SubField(GetFieldSelections(year),',',1)='1999' and right(GetFieldSelections(year),4)='2000') ,1,0)

Thanks,

Itishree

Re: Conditionally show the column based on two values

Fri, 06 May 2016 06:53:06 GMT

Hi Priyadharsini,

Yes true.

Its working fine.

Thnak you so much.

Best regards

Thiru

Re: Conditionally show the column based on two values

Tue, 10 May 2016 12:17:57 GMT

Hi Priya dharsini,

Sorry to say again it's not working.

I want show the column hide and visible based on the selection of year and associative values of year.

You are hiding the rows not complete column

Please do the needful

Thanks

Thiru