How to make an Expression Dynamic.

[onetwothree123]

Currently I am using the following expression in a bar chart,

SUM ( { < Flag ={ 'Y' } > } Mon1) .

Where mon1 refers to first month(Jan).

I want to make it dyanmic so if I make a selection in month list box, it should dislpay corresponding values in Bar chart

(say I make mon4 as selection, bar chart should display data for April(Mon4)  and so on)

[swuehl]

Not sure if I understood your data model correctly, and it may be mucg different than I assume so you may need to detail your data model a bit more, but maybe you could just replace your Mon1 by the not aggregated value field:

=sum({<Flag = {'Y'}>} Value)

and maybe use Month field name as dimension to group by your selected month.

[jagan]

Hi,

If there is a proper mapping between the tables, then qlikview automatically filters the data based on the selected filters.  The charts automatically refreshes if the selection changes.

Regards,

Jagan.

[tresesco]

Hi,

you have to remove the month field from the expression, then it would behave as per selection.

Regards,  tresesco

[onetwothree123]

swuehl,

I have 12 different columns in a table mon1 mon2 and so on.

My current expression is hard coded just for mon1(Jan).

So I am looking for a logic to put  in expression, where I don't have to hard code it mon1 ,mon2 ....... for all 12 months

[swuehl]

So you actually don't have a field Month you can select from?

Maybe you want to use a crosstable load to transform your current table into a straight table, using something like

Crosstable (Month, Data) Load Flag, Mon1, Mon2, ...

from Table;

If you want to use a crosstable load , please check the Manual. You can also use the table wizard to transform your input table.

Hope this helps,

Stefan

[onetwothree123]

Stefan,

I have 12 different fields to select from.

Mon1

.

.

.

....Mon12

[#8]

What stefan is saying is that you should modify your load script in order to transform your 12 fields into 1 with a corss table.

Finally you'll get a month field which you can use in your expression.

Moreover, in your bar chart you can use this month as dimension instead of  i believe that now you have 12 expressions.