topic Re: Set Analysis/ Expression :How to include a value irrespective of the selection ? in QlikView

Set Analysis/ Expression :How to include a value irrespective of the selection ?

ajipaul03 — Sat, 16 Nov 2024 00:01:19 GMT

Hi Experts ,

I have a unique requirement to do certain analysis.

Here is the table structure

I need to write an expression Sum({$<......>}AMT), so that when user makes a selection in the option field, it should always include 'R&M' VALUE_CAT.

ex.

OPTION A selection

OPTION-B Selection

Can someone please help?

I thought of duplicating the R&M for A,B and C OPTIONs but I thought some experts would be able to guide me 🙂

Thanks,

Aji

Taoufiq_Zarra — Mon, 07 Sep 2020 08:25:58 GMT

@ajipaul03 One solution:

=sum({1<VALUE_CAT={'R&M'}>}AMT)+sum({$<VALUE_CAT={"*"}-{'R&M'}>} AMT)

output:

A selected

B selected

Kushal_Chawda — Mon, 07 Sep 2020 10:03:12 GMT

=sum({<OPTION,VALUE_CAT={'R&M'}>+<VALUE_CAT={"*"}>}AMT)

ajipaul03 — Mon, 07 Sep 2020 21:18:52 GMT

Thank you Taoufiq and Kush