Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
pranaview
Contributor II

How to give User an option to restrict the data for the whole app based on a Date

Hi All,

Requirement: User wants a button like toggle where they can limit the data to last 6 months and then can again switch back to the whole data set using the same button/text object.

What I did: I created a Flag to identify the data which falls under Last 6 month range and created a button and used an Action - "Select in Field". This works smoothly on my desktop but the moment the app gets published on access point, the button becomes useless.I have read about triggers not working on access point so i think this why the button doesn't work.

Other option is to create a variable based conditional expressions but since i have lots and lots of sheet objected where I will have to do this, i was wondering if there is any work around or any other way to implement this.

This is quite an urgent requirement from the user, so, any help or suggestion would be great.

Thanks,

Pranav 

1 Solution

Accepted Solutions
pranaview
Contributor II

Re: How to give User an option to restrict the data for the whole app based on a Date

Hi Brett,

I had actually used the same approach which you have suggested. One button to select Flag value to restrict the data to 6 months which i am hiding on click and showing "Clear" button in place of it. But the reason why it was not working in access point was the use of quotations i.e. '1' to select the value for Flag in the Action tab of the button. I removed the quotations and just entered 1 and it started working in access point. Although '1' worked fine in my desktop but did not in access point.

Thanks for your response!

Pranav

View solution in original post

3 Replies
Partner
Partner

Re: How to give User an option to restrict the data for the whole app based on a Date

AFAIK only OnOpen trigger doesnt work on Ajax client. Others should work. I would investigate if some other trigger is interfering with yours.

Alternatively

Why not use your flag as the filter?

e.g. Last 6 Months Flag - values will be Y or null

User can just deselect it.

 

Support
Support

Re: How to give User an option to restrict the data for the whole app based on a Date

Pranav, in addition to Dilip's post, you could use two buttons here with conditional show such only one of them shows at a time and one does your selection to lock it down to the last 6 months whereas the other one does a ClearAll action.  

Regards,
Brett

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
pranaview
Contributor II

Re: How to give User an option to restrict the data for the whole app based on a Date

Hi Brett,

I had actually used the same approach which you have suggested. One button to select Flag value to restrict the data to 6 months which i am hiding on click and showing "Clear" button in place of it. But the reason why it was not working in access point was the use of quotations i.e. '1' to select the value for Flag in the Action tab of the button. I removed the quotations and just entered 1 and it started working in access point. Although '1' worked fine in my desktop but did not in access point.

Thanks for your response!

Pranav

View solution in original post