topic Expression with WHERE clause in QlikView

Expression with WHERE clause

Wed, 14 May 2014 13:30:56 GMT

I am trying to create a chart with an expression where it retrieve results WHERE status is 'New' and 'Resolved'

..and other expression WHERE status is 'Closed'

I tried the following line of expression, but it shows other status.

=if([Status Description] = 'Closed',[Status Description])

Please assist

Re: Expression with WHERE clause

Anonymous — Wed, 14 May 2014 13:35:27 GMT

Try like this:

= Count( if(StatusDescription='New',StatusDescription))

=Count( if(StatusDescription='Resolved',StatusDescription))

Re: Expression with WHERE clause

its_anandrjs — Wed, 14 May 2014 13:38:49 GMT

You can try with

If(Match([Status Description],'Closed'),[Status Description])

or check the supress when value null

Re: Expression with WHERE clause

its_anandrjs — Wed, 14 May 2014 13:42:03 GMT

You can also try with if i am understand your dimension.

If(Match([Status Description],'Closed') And Match(status,'New','Resolved') ,[Status Description])

Re: Expression with WHERE clause

simondachstr — Wed, 14 May 2014 13:42:03 GMT

Use Set-Analysis on the Expression (not Dimension) {<[StatusDescription]={'New',Resolved'}>}

Re: Expression with WHERE clause

Wed, 14 May 2014 13:44:06 GMT

This would be used as a calculated dimension

=if([Status Description] = 'Closed',[Status Description])

else for an expression use=if(only([Status Description]) = 'Closed', only([Status Description]))

anyway if you want to make some count or sum on this status use the set analysis expression like

=sum({<[Status Description] = {'Closed'}>} YourField)

best regards

Chris

Re: Expression with WHERE clause

Wed, 14 May 2014 14:12:12 GMT

I am trying to group and Sum the results for two status and give them a new Status Name

New = 20

Resolved = 10

Closed = 5

This is what I am trying to achieve:

Closed = 5

Open = 30

Re: Expression with WHERE clause

Wed, 14 May 2014 14:17:51 GMT

am trying to group and Sum the results for two status and give them a new Status Name

New = 20

Resolved = 10

Closed = 5

This is what I am trying to achieve:

Closed = 5

Open = 30