topic Re: Expression - condition in QlikView

Expression - condition

Mon, 02 Feb 2015 11:55:33 GMT

Hi, everybody,

I have an straight table with an expression:

count({$<Kód={'M'},Druh={'VP'},Séria={'04. Nominácie_VÚ'}>}Projekt)

How is the correct syntax for setting condition for showing record only if expression value > 3 ?

Thank you in advance.

Duski

Re: Expression - condition

alexandros17 — Mon, 02 Feb 2015 11:56:32 GMT

If(count({$<Kód={'M'},Druh={'VP'},Séria={'04. Nominácie_VÚ'}>}Projekt)>3,

count({$<Kód={'M'},Druh={'VP'},Séria={'04. Nominácie_VÚ'}>}Projekt)

,0)

Re: Expression - condition

Mon, 02 Feb 2015 12:02:38 GMT

Thank you Alessandro,

but I think, my question was not clear for you.

My goal IS NOT TO SHOW ZERO, when the result of the expression is < 3,

but my goal is TO HIDE THE RECORD, if the result of the expression < 3.

Than you in advance.

Duski

Re: Expression - condition

avinashelite — Mon, 02 Feb 2015 12:07:16 GMT

Hi Dusan,

We have option to suppress the 0 values that's why in the above expression he is setting to 0 so that it will meet your requirement of hiding the values

Re: Expression - condition

Anonymous — Mon, 02 Feb 2015 12:10:13 GMT

Hi,

maybe you can use a calculated dimension:

if(

count({$<Kód={'M'},Druh={'VP'},Séria={'04. Nominácie_VÚ'}>}Projekt) >3, YourDimension, null())

and set Supprese When Value is null.

Re: Expression - condition

Mon, 02 Feb 2015 12:17:42 GMT

Thank you, Avinash,

now I understand - I need to put the formula above into the field definition, not into the condition definition.

But the solution doesn't work the way I need 😞 Maybe the problem is that there are many other columns in the table.

I need to show ONLY green records.

Thank you in advance.

Duski

Re: Expression - condition

maxgro — Mon, 02 Feb 2015 12:20:37 GMT

if you only have that expression

if (count({$<Kód={'M'},Druh={'VP'},Séria={'04. Nominácie_VÚ'}>}Projekt) > 3,

count({$<Kód={'M'},Druh={'VP'},Séria={'04. Nominácie_VÚ'}>}Projekt)

)

Re: Expression - condition

avinashelite — Mon, 02 Feb 2015 12:21:58 GMT

Hi Dusan,

What you mean by Green records here??

can you please elaborate your requirement and if possible post you app ? so that we can get the Exact requirement that you r looking for

Re: Expression - condition

Mon, 02 Feb 2015 12:28:10 GMT

There are records 2,6,7,and 9 in the screenshot above marked green (entirely right, column name= Test).

Duski

Re: Expression - condition

alexandros17 — Mon, 02 Feb 2015 12:52:55 GMT

There is a condition: suppress 0 values, if this condition is set then the record disappear automatically (If this is your inly expression)

Hope it helps

Re: Expression - condition

avinashelite — Mon, 02 Feb 2015 13:04:46 GMT

I think you have not selected the suppress ZERO option, go to presentation tab and select the check box

Re: Expression - condition

Mon, 02 Feb 2015 13:12:29 GMT

Thank you, Avinash,

but I have Supress Zero Values checked 😞

I'm afraid, that the problem is, that there are various columns/ expressions in the table...

Thank you in advance.

Duski

Re: Expression - condition

sunny_talwar — Mon, 02 Feb 2015 13:23:41 GMT

Use the same condition for all your expressions in the particular table:

If(count({$<Kód={'M'},Druh={'VP'},Séria={'04. Nominácie_VÚ'}>}Projekt)>3, yourExpression, 0)

This will completely remove those rows.

Hope this is what you are looking for

Best,

Re: Expression - condition

Mon, 02 Feb 2015 13:23:50 GMT

Thank you Alessandro,

but unfortunately, this is not my only expression.

There are various other expressions, but my goal is to hide record according to the value in this only column.

Thanx in advance.

Duski

Re: Expression - condition

sunny_talwar — Mon, 02 Feb 2015 13:29:05 GMT

Or even better option is to put this as a condition is all your other expressions:

If([Test] > 0, yourExpression,0)

This should solve your problem also

Re: Expression - condition

Mon, 02 Feb 2015 13:34:45 GMT

I'm sorry, sunindia, your suggestion doesn't work 😞

"Test" is only label for my column with expression:

count({$<Kód={'M'},Druh={'VP'},Séria={'04. Nominácie_VÚ'}>}Projekt)

Duski

Re: Expression - condition

sunny_talwar — Mon, 02 Feb 2015 13:38:17 GMT

And label is what I am intending for you to use, but make sure its within the square bracket. (It should turn Blue when its within the square brackets []

Best,

Re: Expression - condition

Mon, 02 Feb 2015 13:44:21 GMT

I'm sorry, no blue turn 😞

Error message: Bad field name(s): [Test]

Duski

Re: Expression - condition

sunny_talwar — Mon, 02 Feb 2015 13:44:27 GMT

PFA a sample I prepared for you. Contains two straight table. One where Units are forced to be 0 and second where those 2 rows are completly removed.

Hope this will be helpful.

Best,

Re: Expression - condition

sunny_talwar — Mon, 02 Feb 2015 13:45:44 GMT

Check the sample qvw file I have attached and see if that makes sense. If not then I would suggest you attach a sample file of yours so that we can see what exactly is going wrong.

Best,