topic Help on data in Drill down in QlikView

Help on data in Drill down

Mon, 04 Jul 2011 12:11:16 GMT

Dear all,

I am having 3 data in mt Drill down.

when i click on vessel it drilldowns to portpair and then when i click on portpair it drill downs to Vessel_Voyage.

Now i want one more column with my new data as customer that should also come in my chart when Vessel_Voyage comes through drilldown.

Its Urgent, Please if anyone can Suggest any answer.

Regards,

Pranav

Help on data in Drill down

Mon, 04 Jul 2011 12:37:15 GMT

Dear all,

Can we do something like hiding of Cuatomer as a column and when we drill down and go to Vessel Voyage, we can seek customer column also.

Please suggest any answer.

Regards,

Pranav

Help on data in Drill down

Mon, 04 Jul 2011 12:58:06 GMT

Dear all,

Got the Answer,

Just go to Properties of Chart and in Presentation Module, select the Field as Customer and

Click in option Condition and Place

Condition as =GetSelectedCount(Vsl/Voy)=1

This will give the Solution for Upper Problem.

Regards,

Pranav

Help on data in Drill down

raghavsurya — Mon, 04 Jul 2011 13:02:25 GMT

Hi Pranav,

You can generally hide a column by putting a condition in Presentation tab. Navigation path is

Chart properties > Presentation> Column > Conditional>

an example of the condition can look like "if(getselectedcount(VFSegment)=1,0,1)". Like in your case you can just replace "VFSegment" with you header name of Customer column.

if possible upload a sample qvw file.

Regards,

Raghav