topic Re: set analysis expression in QlikView

set analysis expression

Anonymous — Tue, 25 Jul 2017 06:38:46 GMT

am encountering an error in the below set analysis expression :

count({$<$(vstate)={'x'}>}field) / count({$}field)

the error shown in red curly brackets,

can anyone please help and guide for the above

Anil_Babu_Samineni — Tue, 25 Jul 2017 06:41:13 GMT

What was the variable you declare?

Anonymous — Tue, 25 Jul 2017 06:50:20 GMT

i didnt get your question,

do u want to ask which variable

x is a variable

Anil_Babu_Samineni — Tue, 25 Jul 2017 06:53:08 GMT

That is bug, But if you hit Ok i think condition should work

Nagaraju_KCS — Tue, 25 Jul 2017 06:55:54 GMT

You have declared variable name. vstate

what you have declared in definition ?

mangalsk — Tue, 25 Jul 2017 07:09:51 GMT

is x is value or is it variable, sometimes it shows as red but works.. if x is also a variable then use =$(x) instead of only x

effinty2112 — Tue, 25 Jul 2017 07:21:19 GMT

Hi,

Try : count({$<$(=vstate)={'x'}>}field) / count({$}field)

Good luck

Andrew

Kushal_Chawda — Tue, 25 Jul 2017 07:30:34 GMT

This shows error, but actually it works. Try testing it

pathiqvd — Tue, 25 Jul 2017 08:45:28 GMT

Hi,

May be try like this ,

count({$<statefieldname={"$(varibalename)"}>}field) / count({$}field)

Regards,