topic Re: set analysis based off user input in QlikView

set analysis based off user input

BSCIknowlec — Fri, 15 Nov 2024 23:31:41 GMT

Hi All,

im looking for some advice, i have a text object that will display standard deviation. however i need the calculation to change based on the user input.

there are 4 fields named "distal" "prox", "distal 2" and "prox 2" in my table. each of these fields have values in them. I need my calculation to know that when the user selects the "prox" button, that it will only display the STD for the values in that prox field?

here is my calculation so far,

"=3*(Stdev(Aggr(Sum(distal),BatchSeq,CATHETER)))"

as you can tell, the above calculation will work for the field "distal" but it wont for the others, is there anyway i can replace the distal with a correct function that will display the correct field once the user selects which one they want to view?

thank you ,

Ciarán

Re: set analysis based off user input

marcus_sommer — Wed, 02 Dec 2020 12:56:23 GMT

You could replace the hard-coded field with a variable-value (controlled by one/several buttons or an inputbox) or with a selection (from an island-table) and this may the look like:

3*(Stdev(Aggr(Sum([$(var)]),BatchSeq,CATHETER)))

3*(Stdev(Aggr(Sum([$(=minstring(SelectionField))]),BatchSeq,CATHETER)))

- Marcus

Re: set analysis based off user input

BSCIknowlec — Wed, 02 Dec 2020 13:21:25 GMT

Hi Marcus,

what would the variable look like for these 4 fields? i currently just have a variable named vSection and have a set variable for each button with prox = 1, distal = 2 etc and that works for my filtering, i tried inputting that variable in the calculation but had no luck.

Re: set analysis based off user input

edwin — Wed, 02 Dec 2020 21:55:57 GMT

are you saying for the expression

"=3*(Stdev(Aggr(Sum(distal),BatchSeq,CATHETER)))"

you want distal to be replaced by prox if that is what the user selects? create a variable driven by the user input. such that it is the field you want

"=3*(Stdev(Aggr(Sum($(variableFoField)),BatchSeq,CATHETER)))"

this will be evaluated first and substituted with the value either prox or distal before the expression is evaluated

Re: set analysis based off user input

BSCIknowlec — Thu, 03 Dec 2020 08:30:24 GMT

Hi Edwin, thanks for the information,

yes that is exactly what i am trying to do, there will be 4 buttons on the screen and once the user selects lets say "prox" it will automatically update the STD to calculate it just for the values within the field "prox"

would you know how to go about this? i am a bit of a novice when it comes to these variables,

Re: set analysis based off user input

marcus_sommer — Thu, 03 Dec 2020 09:39:26 GMT

Each button needs to overwrite the value of the variable (it's only a single one for this use-case) with the value respectively fieldname which should be come in use for your calculation.

IMO easier and with more usability and better usage of the screen is the above already mentioned selection-approach. Just creating an island-table and using the field in a listbox. In your case maybe with smething as this:

t: load pick(recno(), 'distal', 'prox', 'distal 2', 'prox 2') as f autogenerate 4;

and then

3*(Stdev(Aggr(Sum([$(=minstring(f))]),BatchSeq,CATHETER)))

- Marcus