topic Re: Set analysis with len( variable) in QlikView

Set analysis with len( variable)

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Guys,

I've built a set analysis for a textbox but i'm having troubles in checking a variable lenght.

sum( {<'$(=vVariable)' = {"=len($(=vVariable)) =0"} >} DIMENSION)

Does anyone have an idea?

Thanks in advance.

Clever_Anjos — Mon, 04 Sep 2017 20:28:31 GMT

Please add this formula as an expression to a straight table with no label on it

Mouse over the header and check how your expression is beeing evaluated

Anil_Babu_Samineni — Mon, 04 Sep 2017 22:18:39 GMT

How you define here vVariable

Anonymous — Tue, 05 Sep 2017 12:24:54 GMT

Hi Anil,

The vVariable here is a number.

Anonymous — Tue, 05 Sep 2017 12:39:39 GMT

Everything seems right in this. but it is not working.

Clever_Anjos — Tue, 05 Sep 2017 12:42:36 GMT

Would you mind posting a screenshot of your test?

Clever_Anjos — Tue, 05 Sep 2017 12:43:52 GMT

vVariable returns a number?

'$(=vVariable)' = {} it´s supposed to be a fieldname so you can use as a Set Analysis expression

Anonymous — Tue, 05 Sep 2017 17:42:37 GMT

Is there a way of putting a number on it?

Anonymous — Tue, 05 Sep 2017 17:50:22 GMT

The function sum( {<'$(=vVariable)' = {"=len($(=vVariable)) =0"} >} DIMENSION)

returns =sum({<'' = {"len()"=0}>} DIMENSION) when I set the variable's value null.

I think the set analysis cannot retrieve a value because it cannot evaluate a null value in the left part of equation (=sum({<'' = ).

Do you have an idea to overcome that?

Thanks in advance.

Clever_Anjos — Wed, 06 Sep 2017 11:52:05 GMT

Let´s start from the beginning...

What´s your intention? Maybe undestanding what you trying to do we can help a little better

A set analysis expression is supposed to have :

Sum({<aField={"Some search expression"}>}Value)

You can have a variable on left side of expression since this variable returns a fieldname