Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

peschu123
Contributor III

How to reduce data with expression?

Hi,

I actually reduce my Data with a trigger.

By field "Datum" and search expr.: "='>=' & weekstart(today(0)) & '<=' & weekend(today(0)+100)"

Unfortunatly this trigger don't seem to work with the Ajax version (QV Access Point)

Is it possible to set this expression for the doc on the server?

Thank you in advance for your help.

Peter

Tags (1)
7 Replies
MVP
MVP

Re: How to reduce data with expression?

I think your Select - Select in field action with above search string should also work in Ajax client.

Have you double checked that the expression produces a search string that seems to be ok (i.e. both date limits and valid date format compared to Datum field)?

You can also create a button to test your action in the Ajax client.

I assume (if you checked the expression), that it's not a matter of your search expression, but of the trigger you are using. What trigger does call the action? Not all triggers work in Ajax, AFAIR.

Re: How to reduce data with expression?

The expression probably isn't the problem, the type of trigger could be. Some triggers don't work in the ajax client. The OnActivateSheet trigger for example can be problematic. See this discussion.


talk is cheap, supply exceeds demand
peschu123
Contributor III

Re: How to reduce data with expression?

Master G is right

My Expression works perfectly in the desktop version. Than I put it on the server and trigger(onsheetactivate) does not work. :-( ...

Later I searched the forums for the triggers, and found some disappointing discussions. Reload and On Open trigger seem to work properly.

I could live with that, when I can manage to set a clear state, which is same like the onload. Else the user gets all weeks shown which are in system. I tried a bookmark, but I couldn't get it to work, that the bookmark is updated for the actual date. Best way would be to shrink data, but it's no sensitive data, so it is no problem if the user has the possibility to explore the data.

@Gysbert: I don't use any buttons, in fact there is only one sheet at the moment, because of the problem described here.

Employee
Employee

Re: How to reduce data with expression?

Hi Peter,

OnActivate and OnDeactivate Sheet Object Event triggers have been removed from QlikView 11.

Bill

peschu123
Contributor III

Re: Re: How to reduce data with expression?

Hi Bill,

in which Version is it removed?

I have QV 11.00.11282.0 SR1.

qv11_triggers.JPG.jpg

Employee
Employee

Re: How to reduce data with expression?

Yes, I see that is still there, but does it work?

Bill

peschu123
Contributor III

Re: Re: How to reduce data with expression?

If you use the QV App directly in the Desktop Version it works.

In Server via AJAX/QV Accesspoint it works not.

Community Browser