Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Two charts on same sheet with different selections of same field

I have a field called "Narative" and want to display two straight table charts on one sheet. One with Narrative value like 'SETTLEMENT*' and othe other the other with all other values

1 Solution

Accepted Solutions
Highlighted
Not applicable

Hi,

that´s a case to use SET Analysis.

Expression a): Sum({$}Amount) //calculate the amount regarding your selection

Expression b): Sum({1-$}Amount) //calculate all other values but not the selected ones

See also QV help for more details.

Good luck!

Rainer

View solution in original post

4 Replies
Highlighted
Not applicable

Hi,

that´s a case to use SET Analysis.

Expression a): Sum({$}Amount) //calculate the amount regarding your selection

Expression b): Sum({1-$}Amount) //calculate all other values but not the selected ones

See also QV help for more details.

Good luck!

Rainer

View solution in original post

Highlighted
Not applicable

Use the set analysis function: (in the following I assume that you need to express sum of amounts, adjust the expressions according to your needs)

Expression in chart #1:
sum( { $ < Narrative = {"SETTLEMENT*"} > } Amount )

Expression in chart #2:
sum( Amount )

regards

Highlighted
Specialist II
Specialist II

see in my example

Highlighted
Contributor II
Contributor II

Problem solved - Thanks