topic Straight Table non selectable rows in QlikView

Straight Table non selectable rows

Thu, 09 Feb 2012 17:20:11 GMT

Hello,

I have this straight table which has Territories as its dimension.

Territory	Volume
A	5
B	10

Presently clicking on any of the rows of territory filters the entire report for that particular territory only.

Desired state:

Clicking on the entities of the territory has no effect.

Methods Tried:

Invisible text box on top of the table. Issues does not render well when viewed with IE plugin.

Any suggestions please

pover — Thu, 09 Feb 2012 17:36:12 GMT

In the volume expression, insert set analysis to ignore a selection to Territory,

sum({$<Territory=>} Quantity)

Karl

Anonymous — Thu, 09 Feb 2012 19:00:09 GMT

Check "read-only" in the chart properties, tab General

Fri, 10 Feb 2012 07:48:11 GMT

There are 4 conditional Dimensions.

I only need to deactivate one of them.

So read only is not applicable here.

Original Expression:

num(sum(distinct(if(product='XYZ',( comparitive.volume)))),'#,##0')

Tried:

num(sum(distinct({$<GeoID=,product='XYZ'>} comparitive.volume)),'#,##0') (Does not work. Error in expression)

Suggestions???

Larry_Aaron — Fri, 10 Feb 2012 07:53:23 GMT

Syntax wise you need { } around the 'XYZ' and some other changes

num(sum({$<GeoID=,product={'XYZ'}>} distinct comparitive.volume),'#,##0')

Fri, 10 Feb 2012 08:57:56 GMT

Thnx a lot guys for helping me out