topic Re: SRType isn't getting activated in QlikView

SRType isn't getting activated

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

Hi Experts!

I have a text object for a metric in the sheet with a value of 5,960 and with the following expression.

=Num(Count({$<[Minutes Bucket]= {'Closed Within 4 hour'}, SRTYPE={'C'}>} DISTINCT [SR ID]),'#,##0')

The expected value of 5,954 shows only when I have a list object of SRTYPE and {'C'} is selected. Why isn't it getting the expected result with just the expression I have? There are a few more metrics in the said sheet that has the same case. However, I can't add a trigger on the sheet using select in field as there are more objects which do not need this condition.

Hoping for you response. Thank you.

Re: SRType isn't getting activated

sudeepkm — Mon, 23 Oct 2017 13:56:25 GMT

you might have some field selections in your current selections that is impacting the SRTYPE excluding 'C'. And those fields might not be added to the set analysis to be selection ignored.

Could you send a screenshot of your sheet along with your current selection.

Re: SRType isn't getting activated

xarapre7 — Mon, 23 Oct 2017 14:34:03 GMT

Thank you for your fast reply Sudeep!

Below are the expected results which is only achieved if I select field, SRType=C. I don't have any other selections except for the year and month.

Re: SRType isn't getting activated

sudeepkm — Mon, 23 Oct 2017 15:49:53 GMT

are you saying that when you select just Year=2016 and Month= JAN then you do not see your text box showing value for this expression?

=Num(Count({$<[Minutes Bucket]= {'Closed Within 4 hour'}, SRTYPE={'C'}>} DISTINCT [SR ID]),'#,##0')

and when you select SRTYPE= C from the list box then it works?

do you see the text object showing any values when you clear all fields.

Re: SRType isn't getting activated

xarapre7 — Mon, 23 Oct 2017 18:08:57 GMT

No. The values are showing but they are not the correct values. They are only corrected if I make that

SRTYPE = 'C' selection which shouldn't be that case as i already have that included in the expression.

Re: SRType isn't getting activated

sudeepkm — Mon, 23 Oct 2017 18:13:42 GMT

would like to take a look at the app if you could share