topic Re: Chart Title in QlikView

Chart Title

upaliwije — Tue, 24 Dec 2013 13:21:21 GMT

In a Chart title I want to show Chart Tile + Product Extracted from dimension field

Eg Achievement + Product A This product A will be selected by user from a list box. Pls help me to do this Thanks

Re: Chart Title

Gysbert_Wassenaar — Tue, 24 Dec 2013 13:28:57 GMT

Use an expression like ='Achievement ' & concat(distinct [Product], ' - '). This way if more products are selected they will be shown as a list of values separated by a - .

Just ='Achievement ' & Product will do fine if you always only select one product.

Re: Chart Title

upaliwije — Tue, 24 Dec 2013 13:36:34 GMT

Thanks It is working. One more thing . I want it displayed in two rows like

Achievement

Product

Pls help me

Re: Chart Title

Gysbert_Wassenaar — Tue, 24 Dec 2013 13:48:39 GMT

On the Caption tab set the Multiline Caption option to 2 lines and use this expression: ='Achievement ' & chr(10) & Product