topic Newbie question, restricting loaded data in QlikView

Newbie question, restricting loaded data

Thu, 18 Aug 2011 23:05:43 GMT

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.

Newbie question, restricting loaded data

swuehl — Thu, 18 Aug 2011 23:34:14 GMT

Hi,

you could use as expression:

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

Regards,

Stefan

Newbie question, restricting loaded data

swuehl — Thu, 18 Aug 2011 23:39:23 GMT

Or, as an alternative and probably easier to read:

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

Newbie question, restricting loaded data

Fri, 19 Aug 2011 00:36:17 GMT

Excellent, thanks!