topic Set in QlikView

Set

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Please find the attachment

I have created a new field form the existing data base

On the dashboard you can see that ther are many text object in which i have used set analysis

Which keeps changing when i make a selections on DRUGRESULT and gives the exact data.

But i want the text object to display the value according the selection of the listbox DRGRSLT.

Thanks Sunny

Your exprssion works for all the chart single and as well as multiple selection ,

But the main text object which has count( distinct PTNUMBER ) is not giving thr appropriate result .

Re: Set

kaushiknsolanki — Mon, 07 Mar 2016 11:46:08 GMT

Hi,

Just use

=count(DISTINCT PTNUMBER)

Which will change the values as per the selection.

Regards,

Kaushik Solanki

Re: Set

swuehl — Mon, 07 Mar 2016 11:47:48 GMT

Maybe you want to clear selection in DRUGRESULT:

=count(DISTINCT {$<DRGRSLT={'Sensitivity'},DRUGRESULT=>}PTNUMBER)

Re: Set

sunny_talwar — Mon, 07 Mar 2016 11:48:14 GMT

Can you elaborate a little more on what exactly are you trying to do?

Re: Set

MayilVahanan — Mon, 07 Mar 2016 11:55:00 GMT

Try like this

=count({<DRUGRESULT=>}DISTINCT PTNUMBER)

Re: Set

smilingjohn — Mon, 07 Mar 2016 11:59:40 GMT

OK in the dashboard ther many text object which need to display the distinct count of patient number depebding on the selection made in the filter DRGRSLT .

Ther is one more text object which will have count(Distinct PTNUMBER) which will give the total of seleted value .

For example i select Sensitivyt ans resisnatnt in the DRGRSLT the other object should be zero and in the sum of this total shoul shown in the text object Count(Distinct PTNUMBER) .

I hope iam clear now

Re: Set

smilingjohn — Mon, 07 Mar 2016 12:01:34 GMT

This someting for over text object , I want to show the value for each DRUGRESULT thats why iam using set analysis and passing single value , and it has to change as per the selection made in the DRGRSLT

Re: Set

sunny_talwar — Mon, 07 Mar 2016 12:03:04 GMT

For making everything else = 0, you can add this condition to all your text box objects:

=If(GetSelectedCount(DRGRSLT) = 0, YourExpression)

If you want to completely hide the text box then you can use the same condition on the layout tab

GetSelectedCount(DRGRSLT) = 0

Re: Set

kaushiknsolanki — Mon, 07 Mar 2016 12:10:24 GMT

Hi,

Try this for each and every text box.

=if(DRGRSLT ='Sensitivity', count(DISTINCT {$<DRGRSLT={'Sensitivity'}>}PTNUMBER),0)

=if(DRGRSLT ='Intermediate', count(DISTINCT {$<DRGRSLT={'Intermediate'}>}PTNUMBER),0)

and other just like this...

Regards,

Kaushik Solanki

Re: Set

smilingjohn — Mon, 07 Mar 2016 12:12:35 GMT

Thanks Sunny

I want to show the value for each DRUGRESULT thats why iam using set analysis and passing single value , and it has to change as per the selection made in the DRGRSLT .

In my attached file whenever i make selection in the filter DRGRSLT its not changing the value in text box .

PLease find my QVW attachment

Re: Set

swuehl — Mon, 07 Mar 2016 12:21:01 GMT

Sorry, I think we still miss what you are trying to do.

In your expressions

=count(DISTINCT {$<DRGRSLT={'Sensitivity'} >}PTNUMBER)

you modify field DRGRSLT, not DRUGRESULT, that's why user selections in DRGRSLT won't change the expression result. And user selections in DRUGRESULT only have an effect if they are compatible /possible with the set modifier for DRGRSLT (edit: otherwise the expression return zero).

Re: Set

smilingjohn — Mon, 07 Mar 2016 12:23:20 GMT

Hi Kaushik

This works with single selection but when i select multiple values in DRGRSLT its not working .

That is if i slelect Sensitivity , Resistant and Intermediate , then the values in all the text object becomes 0

Re: Set

sunny_talwar — Mon, 07 Mar 2016 12:28:01 GMT

Try this in case of multiple selections:

If(SubStringCount(Concat(DISTINCT DRGRSLT, '|'), 'Sensitivity') = 1, Count(DISTINCT {$<DRGRSLT={'Sensitivity'}>}PTNUMBER),0)

Re: Set

smilingjohn — Mon, 07 Mar 2016 12:46:59 GMT

Thanks Sunny this is working on all the text object , But now the main text object which has the expression

Coount( Disticnt Ptnumber) is not giving the corrcte result

Foir example when only one selection is made say for example Resisitant is selected and thge count is 122

then the Count( Disticnt Ptnumber ) = 122

and when multiple selection are made for example i select Resistant and Intermediate which is 122 and 10

then the Count( Disticnt Ptnumber ) should be 132 , which is not showing and it is showing as 122 only

Re: Set

sunny_talwar — Mon, 07 Mar 2016 13:44:21 GMT

Try this expression for the main text object may be:

=Sum(Aggr(Count(DISTINCT PTNUMBER), DRGRSLT))