topic Re: Logic in QlikView

Logic

Fri, 01 Nov 2013 12:55:42 GMT

Fist of all thanks for the continuing help that everyone is giving.

im trying to write a expression logic,

what i want to put is sum all time where taskname = x and y and z

so far have tried sum (time) and TakName ='Amends', but i dont get nothing.

then i want to show this as top ten.

can you help please

Regads

Re: Logic

jvitantonio — Fri, 01 Nov 2013 12:58:10 GMT

Hi,

Try this:

Sum(<1{[TasName]={"x","y","z"} >} Time)

You can look for "Set Analysis" in help for more details.

BI Experience | A place to share our Business Intelligence experiences

Re: Logic

mjm — Fri, 01 Nov 2013 13:17:34 GMT

Hello Tyrone,

to achieve this, you would need to use Set Analysis within the Sum(time) calculation.

I believe this would work for you SUM({1<TakName={'Amends'}>}Time)

This means take a complete set within the sum of time, where TakName=Amends. 1 means the whole data set in this expression.

The sorting can then be achieved in a chart for example, using Y Value descending

Hope this helps. Please mark as answered if this does help.

Thanks

Re: Logic

Fri, 01 Nov 2013 13:37:56 GMT

how do i write that out?

Re: Logic

mjm — Fri, 01 Nov 2013 13:40:44 GMT

I am not sure what you mean by this sorry, but this SUM statement would be used as the expression itself. I understand you want to use this for example in charts, so this would be the expression used for the chart itself.

Re: Logic

jvitantonio — Fri, 01 Nov 2013 13:42:10 GMT

You need to put this in an expression in a chart. Or a text box... Do you have any knowledge of QV? If you want you can attach your app so we can work on it.

BI Experience | A place to share our Business Intelligence experiences