Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Newbie question, restricting loaded data

How should I use the input box in the attached file to restrict the bar chart to those records matching either the owner or user?  For example, if the value of the input box is 1, the chart should show letters a-e AND p-t, if the value is 2 the letters shown should be f-o.  If the value is 0, ALL the letters should be shown.

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Newbie question, restricting loaded data

Or, as an alternative and probably easier to read:

=if($(userid)=0,value,if(owner=$(userid) or user=$(userid),value))

3 Replies
MVP
MVP

Newbie question, restricting loaded data

Hi,

you could use as expression:

=if($(userid)=0,value,only({<letter={"=(owner=$(userid) or user=$(userid))"}>}value))

Regards,

Stefan

MVP
MVP

Newbie question, restricting loaded data

Or, as an alternative and probably easier to read:

=if($(userid)=0,value,if(owner=$(userid) or user=$(userid),value))

Not applicable

Newbie question, restricting loaded data

Excellent, thanks!

Community Browser