topic Re: Customizing staright table in QlikView

Customizing staright table

Mon, 17 Feb 2014 16:40:37 GMT

Hi,

I have created a dimension with drill down group with Project number being my last drill, I have added Project description as one of the expressions which I want to be shown only when I drill to project number and hide it from other drills. My chart type is staright table

Could you please me inputs on how can I do it?

Re: Customizing staright table

Anonymous — Mon, 17 Feb 2014 16:43:57 GMT

You can check this expression as conditional. The condition would be

GetCurrentField(<drill-down group name>) = 'Project number'

Re: Customizing staright table

Mon, 17 Feb 2014 17:18:10 GMT

Hi Michael,

When I used the condition it is showing me the PD desc in every other drill except in the project number drill and the drill before that, it is acting in the other direction

GetCurrentField ('group1') = %Project_Key

could you please provide more inputs

Re: Customizing staright table

Anonymous — Mon, 17 Feb 2014 17:21:14 GMT

I'll be able to provide more input after you upload your application.

Re: Customizing staright table

Mon, 17 Feb 2014 19:20:59 GMT

This is my drill structure, when I am on top line which is CU i still see the PD desc which I dont want to see I only want to see it in Project_key drill , i have also attched the expression

Re: Customizing staright table

Mon, 17 Feb 2014 19:22:45 GMT

Forgot to attach the drill

Thanks

Re: Customizing staright table

Anonymous — Mon, 17 Feb 2014 19:35:23 GMT

Semicolon at the end must be removed.

Also, replace single quotes with the double quotes around the group name.

GetCurentField("Project Analysis Applicant Drill")='%Project_Key'

Maybe there is something else, but can't guess without application.