topic Re: Different Text Boxes to reflect different selections in QlikView

Different Text Boxes to reflect different selections

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

I have 6 text boxes, and each have a different expression in them, i want it so that that expression is displayed constantly and does not change in all the boxes.

Here is an example of the 6 boxes which I would like 6 different numbers to display,

Here is an example of the expressions:

=count(if([Severity] = 'Severe' and [Urgency] = 'High', ([Age] >= '7 Days'),'0'))

=count(if([Severity] = 'Moderate' and [Urgency] = 'Medium', ([Age] >= '60 Days'),'0'))

I believe i need to use something along the lines of:

count(aggr(only(if([Severity] = 'Severe' and [Urgency] = 'High', ([Age] >= '7 Days')),'0')))

Re: Different Text Boxes to reflect different selections

sunny_talwar — Fri, 06 Apr 2018 19:04:00 GMT

Try set analysis

=Count({<[Severity] = {'Severe'}, [Urgency] = {'High'}, [Vulnerability Age] = {">=7"}>} '0')

=Count({<[Severity] = {'Moderate'}, [Urgency] = {'Medium'}, [Vulnerability Age] = {">=60"}>} '0')

Re: Different Text Boxes to reflect different selections

Anonymous — Fri, 06 Apr 2018 19:22:27 GMT

I think this is what I need. However that didn't work. It outputted 1 instead of 12. I want it to count the amount of records which has the severity of severe and urgency of high but only if they have an age of either equal to or above 7 days, if not then 0.

Re: Different Text Boxes to reflect different selections

sunny_talwar — Fri, 06 Apr 2018 19:37:12 GMT

Would you be able to share a list box for [Vulnerability Age]

Re: Different Text Boxes to reflect different selections

Anonymous — Fri, 06 Apr 2018 19:54:07 GMT

Re: Different Text Boxes to reflect different selections

sunny_talwar — Fri, 06 Apr 2018 19:55:21 GMT

Oh, so it is text field.. do you have a value like this >= 7 Days?

Re: Different Text Boxes to reflect different selections

Anonymous — Fri, 06 Apr 2018 19:56:41 GMT

I do not

Re: Different Text Boxes to reflect different selections

sunny_talwar — Fri, 06 Apr 2018 22:31:17 GMT

So what are you trying to do with >= 7?

Re: Different Text Boxes to reflect different selections

Anonymous — Mon, 09 Apr 2018 07:21:22 GMT

I am trying to count every record greater or equal to 7 days, e.g. 8 Days, 9 Days etc

Re: Different Text Boxes to reflect different selections

Mark_Little — Mon, 09 Apr 2018 09:18:49 GMT

Hi,

i would stick with set analysis that Sunny has supplied, but look at formating the your age field to a number.

If formated the same i.e. 1 day so number space day or days., use something like

NUM(SUBFEILD(AGE,' ' ,1)) AS AgeNo.

This would be in the load script.

Then just update the Setanlysis to look at the number field.

Mark

Re: Different Text Boxes to reflect different selections

Anonymous — Mon, 09 Apr 2018 09:33:01 GMT

Hi Mark,

This still did not seem to fix the issue, I am still getting an output of 1 for all boxes.

NUM(SUBFIELD([Age],' ' ,1)) AS AgeNo is what i placed in my script.

Re: Different Text Boxes to reflect different selections

sasiparupudi1 — Mon, 09 Apr 2018 11:51:11 GMT

May be try like this?

count(if([Severity] = 'Severe' and [Urgency] = 'High', (KeepChar([Age],'0123456789') >= 7),'0'))

Re: Different Text Boxes to reflect different selections

sunny_talwar — Mon, 09 Apr 2018 16:27:03 GMT

Would you be able to share a sample to check this out?

Re: Different Text Boxes to reflect different selections

Anonymous — Tue, 10 Apr 2018 08:29:40 GMT

Sample Data attached

Re: Different Text Boxes to reflect different selections

sunny_talwar — Tue, 10 Apr 2018 08:54:11 GMT

Is this what you want?

Re: Different Text Boxes to reflect different selections

chinnuchinni — Tue, 10 Apr 2018 09:32:49 GMT

try this:

LOAD Age,

Severity,

Urgency,

num( SubField(Age,' ',1)) as Age1

FROM

(biff, embedded labels, table is Sheet1$);

and

expression:

=Count({<Age1 = {">=60"},[Severity] = {'Severe'},[Urgency] = {'High'}>}Age)

Re: Different Text Boxes to reflect different selections

Anonymous — Tue, 10 Apr 2018 10:48:30 GMT

Thank you!! Perfect solution!