topic Re: Text Object and Action that will Count and Select a variable whose value is greater than or less than a number in QlikView

Text Object and Action that will Count and Select a variable whose value is greater than or less than a number

Wed, 18 Jan 2017 15:31:41 GMT

I need to have a few text objects that count ITMSNumber where DaysPassed for the ITMSNumber is less than 5, then greater than 5 but less than 10, then greater than 10. Here's some pseudo code-

=Count(IF([DaysPassed]) < 5, ITMSNumber)

=Count(IF([DaysPassed]) < 10 > 5, ITMSNumber)

=Count(IF([DaysPassed]) > 10, ITMSNumber)

SelectInField-

ITMSNumber

DaysPassed < 5

etc.etc.etc...

Re: Text Object and Action that will Count and Select a variable whose value is greater than or less than a number

sunny_talwar — Wed, 18 Jan 2017 15:36:08 GMT

May be these:

=Count({<DaysPassed = {'<5'}>} ITMSNumber)

=Count({<DaysPassed = {'>5<10'}>} ITMSNumber)

=Count({<DaysPassed = {'>10'}>} ITMSNumber)

UPDATE: Here you are( for selection)

To select < 5 ITMSNumber

Field

ITMSNumber

Search String

='(' & Concat(DISTINCT {<DaysPassed = {'<5'}>} Chr(34) & ITMSNumber & Chr(34), '|') & ')'

Do the similar for others

Re: Text Object and Action that will Count and Select a variable whose value is greater than or less than a number

Wed, 18 Jan 2017 15:55:25 GMT

It worked. Now all I need is the SelectInField action that will select only ITMSNumber where it meets the condition of <5, >5<10, and >10.

If you could edit your post and put it in there I will mark it as correct.

Thank you so much!

Re: Text Object and Action that will Count and Select a variable whose value is greater than or less than a number

sunny_talwar — Wed, 18 Jan 2017 15:58:43 GMT

May be like this:

To select < 5 ITMSNumber

Field

ITMSNumber

Search String

='(' & Concat(DISTINCT {<DaysPassed = {'<5'}>} Chr(34) & ITMSNumber & Chr(34), '|') & ')'

Do the similar for others

Re: Text Object and Action that will Count and Select a variable whose value is greater than or less than a number

Wed, 18 Jan 2017 16:04:19 GMT

Ok it worked. Throw it into your first response and I'll mark it as correct. Thank you so much!

Re: Text Object and Action that will Count and Select a variable whose value is greater than or less than a number

sunny_talwar — Wed, 18 Jan 2017 16:23:55 GMT

Its done