Input box value into Expression

Fri, 14 Aug 2009 02:36:44 GMT

Hi,

I have a chart that I am using to display the total magazine orders received by particular publisher alonsgide those for all publishers acheieved currently by using two expressions as follows:

sum({$<[Mag Publisher Name]= 'PUBLISHER_NAME'>} [Gross Subscriptions])

sum({[Gross Subscriptions])

Ideally I now want to be able to pass the value from an input box into the first expression so that the end user can pick which publisher to they want to compare the overall figures against. I have created a variable but can't work out it should be used!

Thanks in advance,

Will

Input box value into Expression

johnw — Fri, 14 Aug 2009 03:20:57 GMT

How about this approach instead:

sum([Gross Subscriptions])
sum({<[Mag Publisher Name]=>}[Gross Subscriptions])

Then select the publisher like normal. One chart will show only that publisher. The other will ignore the publisher selection, show would show all publishers, or at least all publishers that match OTHER selections.

topic Input box value into Expression in QlikView

Input box value into Expression

Input box value into Expression