topic Re: Select only sequences data in QlikView

Select only sequences data

Sun, 13 Mar 2016 10:56:30 GMT

Hi,

I do not know if it's possible but I want that user of my qlikview application is only be able to select the data continuously.

Imagine this example:

The field represents the days of the month.

I do not think that makes sense can select days that are not followed each other , as shown in the image.

I want to ensure that he can only select the days sequentially , as in the following image:

Is there possible?

Thanks

Re: Select only sequences data

swuehl — Sun, 13 Mar 2016 11:47:05 GMT

Maybe using a field event OnSelect trigger (set in Settings - Document Properties - Triggers) with a Selection - Select in field action:

expression for 'Field':

=If(Count(DISTINCT Day) <> (Max(Day)-Min(Day)+1), 'Day')

search expressions:

=Min(Day)

So if you select not a sequence of days, the selection reverts back to the min /start day selection (this could be changed of course to some other selection, or clearing the selection by returning an empty string).

You can also use above expression conditional for Field to show / hide just a text box as an alert, without changing user selections.

Hope this helps,

Stefan

Re: Select only sequences data

swuehl — Sun, 13 Mar 2016 12:17:02 GMT

You can also use this search expression to revert the selection back to the previous selection:

='=Sum({$1} 1)'

So if the user makes a sequence selection, then adds another day value, the previous selection will be restored if the new selection is not a continuous sequence, so he does not lose his previous selection.

Re: Select only sequences data

Digvijay_Singh — Sun, 13 Mar 2016 12:34:20 GMT

Hi Stefan,

This is really great stuff, thanks!

Understood use of $1 to filter to last selection as I could recall but couldn't figure out how Sum(1) expression is properly selecting in field?

Re: Select only sequences data

swuehl — Sun, 13 Mar 2016 12:54:17 GMT

That's basically just a shortcut to use a set of values defined by a set expression as search expression.

The syntax defines an advanced search, similar to =Sum({<Year = {2014}>} Sales) > 10000, so you may understand it better if I would write an avanced search like

=Sum({SET} ConstantValue) > 1

so only records related to the defined SET return a value > 1.

Attached the sample with the above mentioned search expression and an alert text box to help the user understand the revert action.