topic Re: Displaying all text boxes.. in QlikView

Displaying all text boxes..

Anonymous — Tue, 31 May 2016 05:31:07 GMT

Hi all,

I have two text boxes.

One 'Text Box-1' displaying Total Match as 9. This text box, will be displayed only when i click on 'small white square shaped text box-1' down ( circled with red, done with conditional layout ).

Action in small white square shaped text box-1 :

set variable - external variable

value - vShow

Text Box-1 :

Conditional Layout - vShow='totalmatch'

The Second 'Text Box-2' displaying Total Century as 5, will be displayed only when i click on 'small white square shaped text box-2' down ( circled with red, done with conditional layout ).

Action in small white square shaped text box-2 :

set variable - external variable

value - vShow

Text Box-2 :

Conditional Layout - vShow='totalcentury'

The prob is when i click on small white square shaped text box in First Text Box, the second Text Box displaying 'Total Century' is been disappearing. similarly, when i click on small white square shaped text box in Second Text Box, the First Text Box displaying 'Total Match' is been disappearing.

I should get both to be displayed. no matter what i click. Even if i click First, the second one should also display, vice versa the second one.

Thanks..

Re: Displaying all text boxes..

PrashantSangle — Tue, 31 May 2016 05:37:59 GMT

Hi,

Remove conditional expression.

Regards,

Re: Displaying all text boxes..

PrashantSangle — Tue, 31 May 2016 05:40:14 GMT

or go to document Property > Security > Check Show all Sheets and Objects

Regards

Re: Displaying all text boxes..

sujeetsingh — Tue, 31 May 2016 05:41:04 GMT

First of all try assigning integer value to variable in spite text. Just provide me a sample

Re: Displaying all text boxes..

Tue, 31 May 2016 05:43:37 GMT

This issue is because variable vshow will have one value at a time.

when it has totalmatch, it is not Total century.

Use different varibles for text both 2 like

set variable - external variable

value - vShow2

Text Box-2 :

Conditional Layout - vShow2='totalcentury'

Thanks

Khushboo

Re: Displaying all text boxes..

Anonymous — Tue, 31 May 2016 05:46:26 GMT

Sorry I didn't mentioned something.

As you can see in the pic there is one big text box, which has three text-boxes in it. One among them is 'Total Match'

Similarly i have two more text boxes as below with 'Total Venue' and ' Total Won'.

Instead of displaying them separately i planned to do as displaying them all in same place, according to the click i make in those' small white square shaped text box'. So in this case i need to hide rest two text boxes, when i click on first

'small white square shaped text box'. so i made conditional exp. Now can you say solution fr my prob

Thanks.

Re: Displaying all text boxes..

PrashantSangle — Tue, 31 May 2016 05:49:04 GMT

Hi,

Then in conditional Layout for text Box 2 do below modification.

Text Box-2 :

Conditional Layout - vShow='totalmatch'

Regards

Re: Displaying all text boxes..

avinashelite — Tue, 31 May 2016 05:49:24 GMT

check the Action part in both the text boxes...how your setting the variables .....I guess your resetting the sample variable from both the text action ..create one more variable and add independent action to display both

Re: Displaying all text boxes..

Anonymous — Tue, 31 May 2016 05:56:42 GMT

i have got lots of text boxes like above. so i thought it would be easy for me to identify with names..

Re: Displaying all text boxes..

Anonymous — Tue, 31 May 2016 05:58:12 GMT

Yes.. i tried and its working if i create a separate independent variable...

But i was wondering whether i can do with single variable.

Thanks.

Re: Displaying all text boxes..

Anonymous — Tue, 31 May 2016 05:58:27 GMT

Yes.. i tried and its working if i create a separate independent variable...

But i was wondering whether i can do with single variable.

Thanks.

Re: Displaying all text boxes..

Anonymous — Tue, 31 May 2016 06:02:27 GMT

Thanks fr your suggestion.

I think yu got confused.

First text box:

First Big text box has 3 text boxes in it.

Second Text box:

Second Big text box has 2 text boxes in it.

Re: Displaying all text boxes..

avinashelite — Tue, 31 May 2016 06:02:46 GMT

no, it would be bit clumsy ...while setting the variable you need to set with two values and use the match function over it to show the contents ....

Re: Displaying all text boxes..

Tue, 31 May 2016 06:04:17 GMT

I do not think its possible with one variable.

Because a variable can store one value at a time. So when it is totalmatch it is not totalcentury and vice-versa.

Re: Displaying all text boxes..

Anonymous — Tue, 31 May 2016 06:06:48 GMT

okay. thanks..

Re: Displaying all text boxes..

Anonymous — Tue, 31 May 2016 06:07:40 GMT

Sure. Yes match function is right way to do. Thanks