topic Re: Set Analysis is not working using Varaiable in QlikView

Set Analysis is not working using Varaiable

naveen341 — Sat, 16 Nov 2024 04:18:27 GMT

HI Team

I Have a value in the field and value in a varaible i am trying to write and set analysis to see if one value is greater than other its not working

can you please help me with this

HGB_VAL=8.7

$(vHGB)=5

count the Unique_Blood_Unit

formulae i have written is

=count( {<HGB_VAL={">=$(vHGB)"}>} Unique_Blood_Unit

Thanks In Advance

Re: Set Analysis is not working using Varaiable

rubenmarin — Thu, 28 Feb 2019 18:05:04 GMT

Hi, HGB_VAL should be realted with data to apply filters, ie:

SET vHGB=5;

Data:
LOAD * Inline [
HGB_VAL, Unique_Blood_Unit
8.7,2
4,1
];

"count( {<HGB_VAL={">=$(vHGB)"}>} Unique_Blood_Unit" returns 1
"sum( {<HGB_VAL={">=$(vHGB)"}>} Unique_Blood_Unit" returns 2

Re: Set Analysis is not working using Varaiable

naveen341 — Thu, 28 Feb 2019 18:20:04 GMT

it is realted to data

Re: Set Analysis is not working using Varaiable

rubenmarin — Thu, 28 Feb 2019 18:48:26 GMT

HGB_VAL is left-aligned, it means it's beign oinnterpreted as a string not a number,

Try converting it while loading:
LOAD
Num#(HGB_VAL,'.',',') as HGB_VAL,
...

Re: Set Analysis is not working using Varaiable

naveen341 — Thu, 28 Feb 2019 21:10:11 GMT

NO This did not help

Re: Set Analysis is not working using Varaiable

Shubham_Deshmukh — Mon, 04 Mar 2019 11:21:53 GMT

Naveen,

It is working in my case, just check your expression
vHGB= 5;

=count( {<HGB_VAL={">=$(vHGB)"}>} Unique_Blood_Unit)

Regards

Re: Set Analysis is not working using Varaiable

rubenmarin — Thu, 07 Mar 2019 20:27:29 GMT

To make it work HGB_VAL should be a number, to convert a string to a number you can use Num#(), the exact sentence needed may vary based on your local settings for numbers, try different parameters for Num#():
https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/InterpretationFunctions/num_hash.htm

You can try until this expression returns a number: Max(Num#(HGB_VAL,'.',','))+1