topic Re: How to write expression? in QlikView

How to write expression?

Thu, 19 Jun 2014 09:00:50 GMT

can anyone help me with the expression please

attached is the table which should be build in report.

week is in horizontal as week1, week2,week3,week4

for eg: 207 is the difference of count of id if we take today. i,e today(wednesday) minus last week(last wednesday) where Type= 'close','close/forward'
78 is the difference of count of id if we take today. i,e today(wednesday) minus last week(last wednesday) where Type= 'fail','fail/forward'

Thanks.

Re: How to write expression?

Thu, 19 Jun 2014 09:01:01 GMT

please see attached.

Re: How to write expression?

Thu, 19 Jun 2014 09:25:10 GMT

would this be possible to create?

Re: How to write expression?

simondachstr — Thu, 19 Jun 2014 12:49:36 GMT

Are you asking because you can't do it yourself or because you can't bother doing it yourself?

A pivottable would work just fine and you just need to drag the Week-dimension horizontally.

Re: How to write expression?

Thu, 19 Jun 2014 12:54:05 GMT

I tried all but not working. only I have to show is the differences. So, I would need the expression. Is that possible? Please help.

I can get direct with dimension Week and expression as count(ID) . but here this is not the requirement.

Re: How to write expression?

simondachstr — Thu, 19 Jun 2014 13:22:17 GMT

Oh I see,

You will need to write two expressions. One for close, one for fail.

Use set analysis e.g.

Expression 1

Count({Type={'close,'close/forward'} ID)-Count({Type={'close,'close/forward', Week={'$(=Week-1)'} ID)

Expression 2

Count({Type={'fail','fail/forward'} ID)-Count({Type={'fail','fail/forward', Week={'$(=Week-1)'} ID)

Not sure if Week={'$(=Week-1)'} part would work - if possible can you upload a data set of what you are currently using?

Re: How to write expression?

Thu, 19 Jun 2014 13:43:53 GMT

Thanks. will try and let you know.