topic Re: Multiple version selections in QlikView

Multiple version selections

Anonymous — Wed, 09 Oct 2013 06:48:37 GMT

Hello, I´m trying to present comments that explains differences between two versions. What comments to present should be based on what Versions are selected in my economy application. The comments are edited by the business in an excel file where I have two fields for Version.

I´ll try to give a simplified example

I´ve got one transaction table called "Data" that looks like this

Version Account CostCenter Amount

Actual 3100 10 100

Budget 4100 10 120

Forecast1 3100 20 140

Forecast2 4100 20 160

Now I want a textbox to present comments to explain differences between the versions, and I want that textbox to display those comments based on two selections in the field Version. The problem is that in the comments excel file I have two fields for version. This is what I´ve tried but of course it doesn´t work:

Concatenate (Data)

Load

Version1 as Version

Version1,

Version2,

Comment

FROM Comments.xls;

In both Version1 and Version2 the values can be any of Actual, Budget, Forecast1 or Forecast2, but never the same in both fields.

I´ve set up two Variables in the document:

vVersion1 = maxstring(Version)

vVersion2 = minstring(Version)

Statement in the textbox

=If(Version2 = '$(vVersion1)' or Version2 = '$(vVersion2)', Comment)

Doesn´t work of course, but now I´m out of ideas

Re: Multiple version selections

Gysbert_Wassenaar — Wed, 09 Oct 2013 07:25:34 GMT

I'm afraid your explanation is as clear as mud to me. Can you post an example document with example data and what the result should look like? A mock-up is excel might be the easiest way to demonstrate what you need.

Re: Multiple version selections

Anonymous — Wed, 09 Oct 2013 18:28:05 GMT

Really, it´s perfectly clear to me . File attached, hope that makes it clearer.

Re: Multiple version selections

swuehl — Wed, 09 Oct 2013 18:42:07 GMT

In your text box, try

=only({<Version1 = {$(=minstring(Version))}, Version2 = {$(=maxstring(Version))}>} Comment)

Your combinations should always show Version1 as the minimum string, so I think it should be like this

Comment	Version1	Version2
Amount is higher than budget due to new sales strategy	Budget	Forecast1
Amount is lower than budget due to bad weather	Actual	Budget
Amount is lower than forecast due to ......	Actual	Forecast2
Amount is lower than forecast due to delay in marketing activities	Actual	Forecast1