topic Re: Straight Table Filter in QlikView

Straight Table Filter

vardhancse — Wed, 09 Dec 2015 17:59:46 GMT

Hi,

I have one small requirement, can any one help me.

I have 2 straight tables, for eg:

Group1	Actual	Target	Variance	MOM%
Measure1	1	2	-1	-50%
Measure2	2	3	-1	-33%
Measure3	3	4	-1	-25%
Measure4	4	5	-1	-20%
Measure5	5	6	-1	-17%
Measure6	6	7	-1	-14%
Measure7	7	8	-1	-13%
Measure8	8	9	-1	-11%
Group2	Actual	Target	Variance	MOM%
Measure9	1	2	-1	-50%
Measure10	2	3	-1	-33%
Measure11	3	4	-1	-25%
Measure12	4	5	-1	-20%
Measure13	5	6	-1	-17%
Measure14	6	7	-1	-14%
Measure15	7	8	-1	-13%
Measure16	8	9	-1	-11%

The requirement is that, both group1 and group2 measures are coming from one single field but splitted based on some condition.

now i need to display one trend graph, based on the measure selected from either one of the straight table.

1. But the issue is that when ever we are selecting one meaure from one table the other table was going blank. this should not happen.

whatever may be the selection from any table all the table rows should be displayed.

2. When ever i am selecting the measure, the background color was going to white, this should not happen.

3. currently for variance field we can see all the colour back ground colours, should have a funcitonality like if I click on the object all the variance rows except red color should be displayed.

Re: Straight Table Filter

swuehl — Wed, 09 Dec 2015 19:35:02 GMT

A small sample QVW helps to understand your setting, so if possible, upload a small sample application.

In general, you can make your chart expressions insensitive to selections in field 'Measure' (I assume this is the name of your single field) by the use of set analysis.

You need to apply set analysis to all aggregations functions in your expression. For example, if your expression for Actual is

=Sum(Actual)

then

=Sum({<Measure= >} Actual)

will disregard selections in field Measure, this should result in your dimension not filtered when selecting a measure line.

Re: Straight Table Filter

vardhancse — Thu, 10 Dec 2015 02:07:56 GMT

Hi Thanks for your reply.

Yes tried in the same way, but the background color of he variance was going blank