topic calculated dimension query? in QlikView

calculated dimension query?

Thu, 29 Mar 2012 04:08:20 GMT

Hi Everyone ,

I have following columns:- name, employee id , joining date, resigned date, days worked i.e.(resigned date - joined date)

now i want to show in a funnel chart or pie chart, percentage of guys who resigned with dimension being junior, intermediate, seniors (based on days worked if less than 365 then junior, more than 1000 then senior else intermediate)

Can anyone explain me what should i use dimension , ithink i need to use calculated dimension ,, but i am getting the desired result

calculated dimension query?

Thu, 29 Mar 2012 04:21:35 GMT

Use Calsulated dimension as

if((resigned date - joined date)<=365,'Junnior'

if(((resigned date - joined date))>365 and ((resigned date - joined date)<1000), 'Intermediate'

if(((resigned date - joined date))>1000 , 'Intermediate' , ''

)

Regards

Arun Goel

calculated dimension query?

Thu, 29 Mar 2012 05:45:53 GMT

Thanks that works well . One more thing can you explain value list in this context if applicable here.

calculated dimension query?

Thu, 29 Mar 2012 06:05:03 GMT

Sorry..didt get you....??