topic Re: Set analysis and if condition in QlikView

Set analysis and if condition

Wed, 18 Sep 2013 13:28:34 GMT

I am not getting correct data for below expression. Any help will be appreciated.

Expression:

=if(WORKOUTACTION.WORKOUTACTIONSTATUSDrop='Open' or WORKOUTACTION.WORKOUTACTIONSTATUSDrop='InProgress',count ({$<Year=,Quarter=,Month=,Day=>}distinct WORKOUTACTION.ACTIONID),
if(WORKOUTACTION.WORKOUTACTIONSTATUSDrop='Closed',count(distinct WORKOUTACTION.ACTIONID)))

Dimension 1:

=WORKOUTACTION.TYPE

Dimension 2:

=if(WORKOUTACTION.WORKOUTACTIONSTATUSDrop='Open' or WORKOUTACTION.WORKOUTACTIONSTATUSDrop='InProgress','Open',
if(WORKOUTACTION.WORKOUTACTIONSTATUSDrop='Closed','Closed'))

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Thanks in advance..

Regards,

Ankita

Re: Set analysis and if condition

CELAMBARASAN — Wed, 18 Sep 2013 13:39:59 GMT

Hi,

Here you can simply use count({$<Year=,Quarter=,Month=,Day=>} distinct WORKOUTACTION.ACTIONID)

and analyse whether action id is same. if it is same it returns 1.

Re: Set analysis and if condition

Wed, 18 Sep 2013 13:42:43 GMT

try

=if(WORKOUTACTION.WORKOUTACTIONSTATUSDrop='Open' or WORKOUTACTION.WORKOUTACTIONSTATUSDrop='InProgress', if(WORKOUTACTION.WORKOUTACTIONSTATUSDrop<>'Closed',count ({$<Year=,Quarter=,Month=,Day=>}distinctWORKOUTACTION.ACTIONID),count(distinct WORKOUTACTION.ACTIONID)))

Re: Set analysis and if condition

Thu, 19 Sep 2013 05:02:31 GMT

No, on using this expression, chart is not showing any data.

Re: Set analysis and if condition

tresB — Thu, 19 Sep 2013 05:07:44 GMT

Please share a sample app. If you are worried about data and all see How to Prepare Sample File to Upload

Re: Set analysis and if condition

Thu, 19 Sep 2013 06:03:38 GMT

I think there is some error with the dimension because of which I am not getting 'Open' status count correct.

Please give some alternate solution..

below is the dimension:

=if(WORKOUTACTION.WORKOUTACTIONSTATUSDrop='Open' or WORKOUTACTION.WORKOUTACTIONSTATUSDrop='InProgress','Open',
if(WORKOUTACTION.WORKOUTACTIONSTATUSDrop='Closed','Closed'))

Re: Set analysis and if condition

Thu, 19 Sep 2013 06:06:31 GMT

could you share your qvw file?

another thing.. If your status is open or inprogress then its open...... But when not it should be closed?

why not just do like this then

=if(WORKOUTACTION.WORKOUTACTIONSTATUSDrop='Open' orWORKOUTACTION.WORKOUTACTIONSTATUSDrop='InProgress','Open','Closed')