Silly Expression

Wed, 19 Mar 2014 04:12:28 GMT

Some times you have those days when you just forget the basics. Here's mine

Attached is a sample qvw where I am looking to compute the Inactive Turnover% = SUM(Inactive)/SUM(ActiveSummary) and display it on a table by InactiveReason.

It is a snapshot metric and therefore if the dimension is monthly, then it uses the month's values (easily done), if it is Quarterly, then uses end of quarter values for that quarter, if it is yearly, then end of year values.

I know this is possible in an expression but don't remember if I need to create the associated QuarterEnd and YearEnd values for each record in my MasterCalendar when I ultimately add it or can I do it without it.

For instance,

LOAD * INLINE [
    AsOfDate, Active, Inactive, InactiveReason
    1/31/2013, 1776
    1/31/2013, , 3, Voluntary
    1/31/2013, , 5, Involuntary

    2/28/2013, 1278
    2/28/2013, , 56, Voluntary
    2/28/2013, , 34, Involuntary
    3/31/2013, 1852,
    3/31/2013, , 40, Voluntary
    3/31/2013, , 60, Involuntary
    4/30/2013, 1298,
    4/30/2013, , 48, Voluntary
    4/30/2013, , 52, Involuntary

];

If put in a straight table with Year and Quarter as the dimensions with Inactive Reason, I want Inactive % to be 40/1852 for Voluntary and 60/1852 for Involuntary.

any assistance is appreciated

Re: Silly Expression

qlikpahadi07 — Wed, 19 Mar 2014 05:48:47 GMT

Hi Amir,

PFA may be this you are looking at ?

Re: Re: Silly Expression

Wed, 19 Mar 2014 13:17:38 GMT

that's not it. I found the solution by using flags to denote the QUarterEnd or MonthEnd and if the cycle is on quarter, then it uses the Quarter End values of the snapshot data.

See attached solution

Re: Silly Expression

qlikpahadi07 — Thu, 20 Mar 2014 06:14:47 GMT

great

topic Re: Silly Expression in QlikView

Silly Expression

Re: Silly Expression

Re: Re: Silly Expression

Re: Silly Expression