How to include a variable value in Window Text

Mon, 23 Apr 2012 20:23:58 GMT

I am relatively new to Qlikview. I set up an classification filter based on a formula =Year([ship date]). Two problems-

1) The drop down list gives me the 4 digit year. However when I select a year (e.g. 2013), the current selections shows 33 out of 679 in the values column for this calculated field. Why doesn't it show 2013?

2) I would like the Window Title on one of the sheet objects to be a combination of words and the ship date year value. I haven't been able to get it to work properly.

Any help will be appreciated.

Steve

How to include a variable value in Window Text

swuehl — Mon, 23 Apr 2012 20:35:36 GMT

1) You are actually selecting in field [ship date], not in Year (well, there is no field), that's why it shows something like 33 of 679 and not a single value like 2013.

You could add a year field to your data model and use this instead of the expression in your list box.

2) Maybe

='Some words' & year([ship date])

as expression for your caption text.

topic How to include a variable value in Window Text in QlikView

How to include a variable value in Window Text

How to include a variable value in Window Text