Discussion Board for collaboration related to Creating Analytics for QlikView.
I have combo chart with title,along with title i want to display one-by-one field names.
Ex:- My title is Brand analysis and i have different fields like field1,field2,field3 in three different dimensions.
When i selecting one-by-one fields,I want output like this in caption,
like this i want in caption..
any one having the idea about this.
Go to Solution.
='Brand Analysis ' & if(not isnull(field1),'-'&field1) & if(not isnull(field2),'-'&field2) & if(not isnull(field3),'-'&field3)
You need to use something like this :
'Brand Analysis - ' & Concat(Distinct Subfield( GetCurrentSelections('==', '=='), '==', ValueLoop(1, 1000, 2)), ' - ')
This expression works on all the charts and irrespective of any dimension. However, you need to change the ValueLoop contents where I have used maximum value as 1000 but you can use any value based on your dataset.
Hi Phil & Deepak,
Thanks for your reply and solutions.