topic Re: Single select dimension on Straight table in QlikView

Single select dimension on Straight table

mayankraoka — Fri, 03 Jun 2016 14:15:23 GMT

Hi Team,

I have a to restrict the dimension customer name as single select on grid(Straight) report.Assume the below scenario:

I have straight table with customer as dimension and metrics as Volume and,Growth ...

Now I want user to have permission to select only 1 customer from grid report.I dont have list box filter for customer.The only way user can select is from Chart.Is there any way we can do that?I know 1 way where we can restrict to select 1 customer and if they select more than one customer chart will get disabled.But is there any better way without disabling chart?

Any help will be appreciated.

Regards,

Mayank

Re: Single select dimension on Straight table

swuehl — Fri, 03 Jun 2016 14:23:17 GMT

You could try creating a trigger on field selections that fires a select in field action for the customer field that will clear the customer selections if more than one value is selected (or restrict the selection to a single value e.g. to the first selected customer in load order).

Re: Single select dimension on Straight table

mayankraoka — Fri, 03 Jun 2016 14:31:09 GMT

Hi swuehl,

Can you please demonstrate how to achieve this?

Regards,

Mayank

Re: Single select dimension on Straight table

swuehl — Fri, 03 Jun 2016 14:36:41 GMT

Maybe like in this sample QVW. Try to select in the chart more than one SalesBranch.

Re: Single select dimension on Straight table

mayankraoka — Fri, 03 Jun 2016 14:47:36 GMT

Thank you very much Swehl that work .....