topic Set Analysis with Variables- between two variable amount fields in QlikView

Set Analysis with Variables- between two variable amount fields

Wed, 22 Feb 2017 18:51:03 GMT

I am trying to show a text box that counts the number of ids that fall within these two variable amounts- vHighDollar and vLow Dollar. I tried this as a set analysis too using the wizard (see below the first calculation) but neither are working

Original Calculation attempt:

=' Targeted Population ' & Num(If(Paid_Amount<=vHighDollar and Paid_Amount>=vLowDollar, count({[1]}ID_Number)),'###,##0')

Set analysis attempt?

=Count({1<={">=$(=vLowDollar)<$(=vHighDollar)"}>}ID_Number)

Once i make a selection of claim number in the list box, I don't want this targeted population number to change.

I have ANOTHER text box next to it that I want to show the same thing except once i make a selection, i want that number to show the count of selections of id numbers that fall between those variable paid amounts.

Could you please show me both ways of doing this (set analysis and if statement)? Thanks!!

Re: Set Analysis with Variables- between two variable amount fields

sunny_talwar — Wed, 22 Feb 2017 18:54:02 GMT

May be this:

=Count({1<ID_Number = {"=Paid_Amount >= vLowDollar and Paid_Amount < vHighDollar"}>}ID_Number)

Re: Set Analysis with Variables- between two variable amount fields

Wed, 22 Feb 2017 20:26:17 GMT

Hi Sunny! That works for the second box, but I want this number to stay static no matter what selection I pick. I tried changing the 1 to $ but that didn't work.

How can I make this number stay the same if I pick an ID that meets these qualifications?

aka its showing 100, when I choose an ID it goes to 1.

Re: Set Analysis with Variables- between two variable amount fields

sunny_talwar — Wed, 22 Feb 2017 20:30:08 GMT

How do you define vLowDollar and vHighDollar? Are these hardcoded values or expressions?

Re: Set Analysis with Variables- between two variable amount fields

Mon, 27 Feb 2017 14:10:54 GMT

These are variables that get defined through an input box

Re: Set Analysis with Variables- between two variable amount fields

sunny_talwar — Mon, 27 Feb 2017 14:16:59 GMT

Try this:

=Count({1<ID_Number = {"=Only({1} Paid_Amount) >= vLowDollar and Only({1} Paid_Amount) < vHighDollar"}>}ID_Number)

Re: Set Analysis with Variables- between two variable amount fields

Mon, 27 Feb 2017 14:26:19 GMT

Thanks, Sunny!