Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

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

View solution in original post

5 Replies
sunny_talwar

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
Author

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!

sunny_talwar

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
Author

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

sunny_talwar

Its done