topic Re: calculating values using >,< symbols and inputbox in QlikView

calculating values using >,< symbols and inputbox

Wed, 25 Nov 2020 16:16:04 GMT

Hi All
I have data as below

country    Population   income
a           100          10
b           200          20
c           300          30
d           400          40

i need drop down list box, in which i want population or income as field values
i need another drop down list box which should contain >,<,>=,<= as values
i need a input box where i can give input values as numbers

my selection will be as below

my output will be

straight table

Re: calculating values using >,< symbols and inputbox

MK_QSL — Mon, 28 Nov 2016 18:38:12 GMT

Create two Variables.

Symbol and Value

SUM({<country = {"=Sum(Population)$(Symbol)$(Value)"}>}Population)

Re: calculating values using >,< symbols and inputbox

MK_QSL — Mon, 28 Nov 2016 18:41:45 GMT

If you want to load Symbol as Inline table and use them as List box Selection... add below in your script..

Load * Inline

[

Symbol

];

Now use expression as below.

SUM({<country = {"=Sum(Population)$(=GetFieldSelections(Symbol))$(Value)"}>}Population)

Re: calculating values using >,< symbols and inputbox

MarcoWedel — Tue, 29 Nov 2016 00:07:50 GMT

Hi,

some similar solution might be:

Only({$<country={"=$(=vField&vOperator&vValue)"}>} $(vField))