help with Adhoc Report

[arusanah]

Hi,

I'm creating Adhoc report .  which pulls dimension from an excel .

I have field  %KEY_PROD in DM. I am creating another dimension from this key field using  epression RIGHT(LEFT(%KEY_PROD,8),4),

dim_Category	dim_Name	FieldName
Material(Trans)	P3#	RIGHT(LEFT(%KEY_PROD,8),4)

when I load it in Application. It doesnt pull any value in P#3.

pls help!!

[settu_periasamy]

Hi,

Can you post the sample data and expected out?  It would help us give the better solution

and instead of right,left.. you can try the mid function.

like this  =mid('ABCDEFGHI',5,4)

[jagan]

HI,

Please attach some sample data and your expected output so that it would be easily understand and provide the solution.  Hope below link helps you in getting the answer faster

Qlik Community Tip: Posting Successful Discussion Threads

Regards,

Jagan.