Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vardhancse
Specialist III
Specialist III

Straight Table Filter

Hi,

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

I have 2 straight tables, for eg:

Group1ActualTargetVarianceMOM%
Measure112-1-50%
Measure223-1-33%
Measure334-1-25%
Measure445-1-20%
Measure556-1-17%
Measure667-1-14%
Measure778-1-13%
Measure889-1-11%
Group2ActualTargetVarianceMOM%
Measure912-1-50%
Measure1023-1-33%
Measure1134-1-25%
Measure1245-1-20%
Measure1356-1-17%
Measure1467-1-14%
Measure1578-1-13%
Measure1689-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.

2 Replies
swuehl
MVP
MVP

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.

vardhancse
Specialist III
Specialist III
Author

Hi Thanks for your reply.

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