topic Change Dimension Label in QlikView

Change Dimension Label

swati_rastogi27 — Fri, 18 Mar 2016 11:14:22 GMT

I have a column CURR_CD which displays Currency codes like EUR,GBP etc.

All my calculations like 'Total No. of Invoices booked' , 'Total Value of Invoices booked' etc are grouped by Currency.

In my straight table I will use CURR_CD as my dimension , but I want to display the dimension text as No. of Invoices booked in EUR etc.

For depiction purpose , I will show the data in excel format:

Current output is :

Required output is:

sunny_talwar — Fri, 18 Mar 2016 13:41:25 GMT

Maye be change your dimension to a calculated dimension:

='No of Invoices booked in ' & CURR_CD

pooja_sn — Fri, 18 Mar 2016 13:47:36 GMT

Add a calculated dimension as

'No of Invoices booked in ' & CURR_CD