topic Re: Field Index in QlikView

Field Index

Thu, 14 Jun 2012 12:32:15 GMT

I have a table like this. I have to get the first product from the table using FieldIndex. i.e. I have to show chart for each product seperately for different month. I can't hard code it and use calculated dimension as " if(Product='Product 1', Product) " as my chart has to be dynamic so that even if the product name changes it works. So is there a function which identifies the product present in the Product column. FieldIndex is one but i am not able to use it as i don't know its syntax. Any suggestion ??

Thanks in Advance

Product	VolumeM1	VolumeM2	VolumeM3	VolumeM4	VolumeM5
Product 1	10	12	13	10	8
Product 2	15	5	6	9	12
Product 3	8	5	9	7	9
Product 4	12	9	8	12	11
Product 5	6	8	14	12	14

Re: Field Index

swuehl — Thu, 14 Jun 2012 12:46:53 GMT

If you don't know the syntax, just look it up in the Help file (F1 is your little helper for that). I think you need to look for fieldvalue() instead of fieldindex(), since the value of the field is what you are interested in, right?

I believe it will look like

=if(Product=FieldValue('Product',1),Product)

Re: Field Index

lironbaram — Thu, 14 Jun 2012 12:47:37 GMT

please check attach file

hope it gives you any help

Re: Field Index

Thu, 14 Jun 2012 12:50:50 GMT

Thanks Swuehi.. It works

Re: Field Index

Thu, 14 Jun 2012 12:53:18 GMT

Thanks for your help Liron