topic Re: Dashboard Sheet in QlikView

Dashboard Sheet

n1ef5ng1 — Thu, 08 May 2014 08:24:24 GMT

I have this qvw that has few tabs, on the first tab it is an overview dashboard.

In this dashboard, it contains 10 chart namely salesperson, salesteam, Region, Type, etc etc

Only salesperson and salesteam is in table form while the rest is bar/line chart.

However in this dashboard, I would want user to only have selections from salesperson and salesteam. User are not allow to filter in Region , type perspective.

Is there any way i can restrict this to the user?

Re: Dashboard Sheet

n1ef5ng1 — Thu, 08 May 2014 10:00:58 GMT

anybody know?

Re: Dashboard Sheet

sudeepkm — Thu, 08 May 2014 10:07:45 GMT

you may use Readonly in the Charts.

Re: Dashboard Sheet

Roop — Thu, 08 May 2014 10:12:39 GMT

I think that I understand your issue ....

You can use Set Analysis to define your measures for you in your charts etc.

So instead of having:

Sum(Sales)

use

Sum({$<Region = >} Sales)

This would exclude Region from any selection and you can increase this to whatever you wish.

Re: Dashboard Sheet

n1ef5ng1 — Fri, 09 May 2014 00:51:37 GMT

thanks, i guess I have overlooked this option for the past months. I diden know there is this read only check box exist