topic Re: employee count for active in QlikView

employee count for active

vikasmahajan — Thu, 20 Jun 2013 12:27:24 GMT

Dear All

I have employee master with active and in-active flag how to show only active employee's in straight table

Thanks in Advance

Vikas

m_woolf — Thu, 20 Jun 2013 12:55:36 GMT

You can use set analysis in the expression, something like this:

sum({<Flag = {'A'}>}Amt)

You can also use a calculated dimension:

=if(Flag = 'A',Employee)

Thu, 20 Jun 2013 13:07:48 GMT

Hi,

Hope it will work

RawData:LOAD * INLINE [
Employee,Flag
v1, Active
v2, IN-Active
v3, Active
v4, IN-Active
v5, Active

];

In Straight Table Take Dimension Employee , Flag

Expression = Sum({<Flag={'Active'}>}1)

Then Hide Expression in Presentation Tab