topic Dimension value set table selection in QlikView

Dimension value set table selection

Tue, 07 Apr 2015 12:12:08 GMT

Hi there,

I have a table of budgets based on months, please see below for example.

Financial Month	Budget
January	15,000
February	20,000
March	25,000
April	30,000

I also have a data dimension that contains financial month data.

Effectively, what I want, is to be able to set a variable based on the selection of a dimension value. So if the financial month value of 'January' is selected, the variable can be set to 15,000.

Hope that makes sense.

Re: Dimension value set table selection

Tue, 07 Apr 2015 12:15:00 GMT

Create a new Variables in qvw like:

=Only(Budget)

This work if a single value of Budget is possible, otherwise returns null

Re: Dimension value set table selection

Roop — Tue, 07 Apr 2015 12:19:52 GMT

Create a New Variable and give it the value of:

=Sum(Budget)

This will ensure that is calculated if you select more than 1 month

Rupert

Re: Dimension value set table selection

buzzy996 — Tue, 07 Apr 2015 12:23:37 GMT

try this,

create variable and assign ur month dimension to that variable.

tht helps to automaticly the corresponding month value whenever u select a particular month.