Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

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

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...

1 Solution

Accepted Solutions

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

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

5 Replies

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

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

Not applicable

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

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

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

Not applicable

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

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

Its done