topic Re: conditional column on the basis of drilldown in QlikView

conditional column on the basis of drilldown

Thu, 03 Jul 2014 12:19:54 GMT

i have one straight table, in which one column is dril down group.

currently i have 3 columns name,gross,net,allowances.

Name is drilldown group upto 3 levels- say manager,teal lead,employee

Now i want to show 5th column as month when i drii down upto 3rd level as employee.

meaning when i select 3rd level-employee month column should be added in column

before-

Name(manager/teamlead) gross net allowances

when I drill down to level emplyee,table will show month column

Name(employee) month gross net allowances

I tried using getcurrentselection(), but gives me whole hierarchy when go to 3rd level like (manaer:(manager name:) |Teal Lead: (Team lead name) | employee:(employee name))
how can i check that i have selected employee now ???

Re: conditional column on the basis of drilldown

jonathandienst — Thu, 03 Jul 2014 12:23:23 GMT

What about:

GetSelectedCount(employee) = 1

for the condition?

HTH

Jonathan

Re: conditional column on the basis of drilldown

Thu, 03 Jul 2014 12:31:12 GMT

Its drilldown group dimension

Re: conditional column on the basis of drilldown

mahesh_agrawal — Thu, 03 Jul 2014 12:37:48 GMT

Hi,

You have to use the GetCurrentFields() in the Conditional box for that column.

Please find the attached QVW(Don't Reload the doc).

Re: conditional column on the basis of drilldown

Thu, 03 Jul 2014 12:46:03 GMT

Mahesh, its correct, its working now