topic Re: Creating Textbox according to if statement (condition) in QlikView

Creating Textbox according to if statement (condition)

Tue, 22 Oct 2013 15:59:40 GMT

Hello together,

I need some help. It is very easy to create a Textbox using a if Condition to display text.

But it only works if I select a Value.

Textbox condition:

=if(columnA='example',(if(columnB>1,'TEST')))

This wokrs fine if I select emaple wtihin the tabelchart (diagram).

Is it posible to get a result within the Textbox without a selection using if statement (condition)?

Thanks Thomas

Re: Creating Textbox according to if statement (condition)

israrkhan — Tue, 22 Oct 2013 16:03:58 GMT

i did not get you exactly, what and when you want to show in text box.

What is Test,

is it a value or Text?

and you can use set analysis and all other functions in text object.

Re: Creating Textbox according to if statement (condition)

Gysbert_Wassenaar — Tue, 22 Oct 2013 16:51:51 GMT

Sure, just use a different aggregation function than the implicit only function for example maxstring: =if(maxstring(columnA)='example',(if(maxstring(columnB)>1,'TEST')))

Re: Creating Textbox according to if statement (condition)

Wed, 23 Oct 2013 09:47:30 GMT

Hello together,

thanks for your answer. Test is the shown TEXT within a Text box.

I trie to Explain it more detailed:

Sorry but I am not able to upload a example. Something ist wrong with my browser etc.

Example:

TableChart: Beispiel Anzeigen / Ausblenden

Includes following condition: If(SpalteA='a',If(SpalteB= 2,sum(SpalteB),0))

Result: only needed rows will be displayed if contion = true, TabelChart ist empty if conditoin = flase

1) Addtional function needed:

I need a Text box like above to show some text if the result of this condition = false (if TableChart: Beispiel Anzeigen / Ausblenden is empty)

Thanks Thomas

Re: Creating Textbox according to if statement (condition)

Marcoimp — Wed, 23 Oct 2013 16:51:55 GMT

Maybe you just have to use the "else" part of the if() function...

If( SpalteA='a',

If(SpalteB= 2,

sum(SpalteB),0),'SOME OTHER TEXT')

What's wrong?!

Re: Creating Textbox according to if statement (condition)

Thu, 24 Oct 2013 08:46:37 GMT

Hello,

thanks for your answer. It doesn't work.

Now allways 'SOME OTHER TEXT' will be displayed. It doesn't matter which value is in SpalteA or SpalteB in Statement below.

For example:

If( SpalteA='f',

If(SpalteB= 3,

sum(SpalteB),0),'SOME OTHER TEXT')

He allways shows
'SOME OTHER TEXT'.

The second part is, that I need text if the result of this condition = false.

TableChart: Beispiel Anzeigen / Ausblenden is empty

Thanks Thomas

Re: Re: Creating Textbox according to if statement (condition)

Marcoimp — Thu, 24 Oct 2013 09:18:39 GMT

You allways get "SOME OTHER TEXT" because SpalteA is allways <>'f', (as in you picture).

Include the qvw example (using the extended editor you'll find the function down right).

Re: Creating Textbox according to if statement (condition)

Thu, 24 Oct 2013 10:45:39 GMT

Hi,

Thanks for answer. Sorry but I have no extended editor. Something is wrong with my browser: Other browsers don’t work too.

But it's possible to upload document on the QlikView page in generally.

You will find the Document under the Recource Library.

Title: Creating Textbox according to if statement (condition)

Thanks Thomas

Re: Creating Textbox according to if statement (condition)

Thu, 24 Oct 2013 10:51:45 GMT

Hi,

I have a second problem. I tried to highlight the tap of this example in red according to a condtion. But for some reason it won't work.

Maybe you have an idea. You will find detailed information in following dicusion:

Higlight a tap (Worksheet) accroding to a condition

Thanks Thomas

Re: Creating Textbox according to if statement (condition)

swuehl — Thu, 24 Oct 2013 10:52:09 GMT

Thomas,

I don't really get what you are trying to achieve, but as mentioned above and in one of your previous threads, you can't compare a field to a single value unless there is only one possible value for that field

SpalteA = 'f'

What are you expect QV to return here? SpalteA is an field (or a vector / array) that contains 5 values, so QV don't know how to evaluate this comparison unless you select a value in SpalteA.

You can add some aggregation functions to get around this, like suggested above or maybe like

=concat( If(SpalteA = 'f', 'Some Text'))

Re: Creating Textbox according to if statement (condition)

Thu, 24 Oct 2013 11:08:37 GMT

Hi,

please have a look on my Example. In this example you will see some tablecharts.Both tablecharts have some condtions to highlight value. The second tablechart in additon has a formula. The result is, that I only get rows according to a condition. This functions work fine.

What I need is in additoin a Textbox if the condition for TableChart: Beispiel Anzeigen / Ausblenden is false. No rows will displayed. So the user willl be informed that he don't have to expect rows / vales.

Thanks Thomas

Re: Creating Textbox according to if statement (condition)

swuehl — Thu, 24 Oct 2013 11:15:47 GMT

So maybe like:

=if(Sum(If(SpalteA='a' and SpalteB>= 2,SpalteB)), 'Tabelle zeigt was', 'Tabelle zeigt nichts')

Re: Creating Textbox according to if statement (condition)

Thu, 24 Oct 2013 12:06:57 GMT

Hi,

thanks for your answer. I tried this, because I have more than one condition:

=concat(If(SpalteA='a',If(SpalteB>= 2,'Tabelle zeigt was'),

(If(SpalteA='c',If(SpalteB= 1,'Tabelle zeigt was'),'Tabelle zeigt nichts'))))

you will see I chaned the values in SpalteB for a test. Now it works. The last problem I have is that he shows 'Tabelle zeigt nichts' twice times. On which position do I have to do that within the statement

Thanks Thomas

Re: Creating Textbox according to if statement (condition)

Thu, 24 Oct 2013 12:08:11 GMT

Hi,

your Statement is working too. I trie to do that with two conditions

Thanks Thomas

Re: Creating Textbox according to if statement (condition)

swuehl — Thu, 24 Oct 2013 13:24:58 GMT

Thomas Walldorf wrote:

. The last problem I have is that he shows 'Tabelle zeigt nichts' twice times. On which position do I have to do that within the statement

Use DISTINCT qualifier:

=concat(DISTINCT If(SpalteA='a',If(SpalteB>= 2,'Tabelle zeigt was'),

(If(SpalteA='c',If(SpalteB= 1,'Tabelle zeigt was'),'Tabelle zeigt nichts'))))

Re: Creating Textbox according to if statement (condition)

offjunior — Thu, 24 Oct 2013 13:29:25 GMT

Good day friend!

I can help you, but need you to be more clear and specific about what you need. First things first, I've downloaded your files qvw, which the first step which you wish to make in that file? Answer me that and I'll be here to help you.

Reminding me explain very well what you want.

Hugs.

Re: Creating Textbox according to if statement (condition)

Thu, 24 Oct 2013 13:43:43 GMT

hi,

thanks a lot Junior Junior.

See the picture above.

In the Texbox I have included:

=concat(If(SpalteA='a',If(SpalteB>= 2,'Tabelle zeigt was'),

(If(SpalteA='c',If(SpalteB= 1,'Tabelle zeigt was'),'Tabelle zeigt nichts'))))

If you can see I get several times a solution (text)

What I need is to display some text if tablechart Beispiel Anzeigen / Ausblenden is empty.

Thanks Thomas

Re: Creating Textbox according to if statement (condition)

Thu, 24 Oct 2013 13:55:08 GMT

Hi Junior Juniior,

because it won't really work I tried this one within Textbox:

if(Sum(If(SpalteA='a' and SpalteB>= 2,SpalteB)),

If(SpalteA='a' and SpalteB>= 2,SpalteB),'Tabelle zeigt nichts')

This works but only if I have maximum two conditions If I try to add a third If Statement it won't work.

Thanks Thomas

Re: Creating Textbox according to if statement (condition)

Thu, 24 Oct 2013 13:58:09 GMT

Hi Junior Junior

Sorry I did a mistake:

Now the correct Statement

if(Sum(If(SpalteA='a' and SpalteB= 2,SpalteB)),

If(SpalteA='c' and SpalteB= 1,SpalteB),'Tabelle zeigt nichts')

This works but only if I have maximum two conditions If I try to add a third If Statement it won't work.

Thanks Thomas

Re: Creating Textbox according to if statement (condition)

offjunior — Thu, 24 Oct 2013 15:16:51 GMT

Please give me a complete sentence with the third condition you are saying it does not work.