Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

Keep results to compare with selections on the same chart

Hey Guys

I have a chart that is plotting 2 values: "Rate1" and "Rate2", where "Rate1" is based on "Cod." selection. The problem is that when i select one "Cod.", both of the rates (Rate1 and Rate2) change and i need to maintain the values of "Rate2" to compare with the selection.

Here is a print of the situation:

Chart.png

Can anybody suggest a solution to this problem?

Thanks

1 Solution

Accepted Solutions
wallinpeter
New Contributor III

Re: Keep results to compare with selections on the same chart

Hmm, should have worked. Something else going on. Usually a bookmark is just saved selections, so it is possible your set statement needs more modifiers.

1) Open the current selections box

2) select Bookmark01

3) note all fields that get selected

4) add them to your set statement, excluding date field.

expression should be...

sum({$<Cod={'*'}, SelectedFieldinBookmark={'SelectedValueInBookMark'}>} Rate2)

View solution in original post

4 Replies
wallinpeter
New Contributor III

Re: Keep results to compare with selections on the same chart

Assuming you have 2 expressions in chart.

sum(Rate1)

and

sum(Rate2)

Change Rate2 expression to....

sum({$<Cod={'*'}>} Rate2)

Not applicable

Re: Keep results to compare with selections on the same chart

Hi Peter

Excellent idea. I get the results correctly, but using bookmark:

          sum({Bookmark01<Cod={'*'}>} Rate2)

But now, my only problem is that i have a period selection that is saved with my desire selections filters in the "Bookmark01" and needs to be flexible and move together with the dates in the "Rate1" and "Rate2".

Resuming: How can i create a parcial Bookmark.. (fixed selections + move selections)?.. Do you have any idea how to solve this problem?

Thanks

wallinpeter
New Contributor III

Re: Keep results to compare with selections on the same chart

Hmm, should have worked. Something else going on. Usually a bookmark is just saved selections, so it is possible your set statement needs more modifiers.

1) Open the current selections box

2) select Bookmark01

3) note all fields that get selected

4) add them to your set statement, excluding date field.

expression should be...

sum({$<Cod={'*'}, SelectedFieldinBookmark={'SelectedValueInBookMark'}>} Rate2)

View solution in original post

Not applicable

Re: Keep results to compare with selections on the same chart

Ok Peter, it's working!

Thank you very much