topic Re: how to write more values in script? in QlikView

how to write more values in script?

Thu, 17 Apr 2014 06:55:40 GMT

hi guys ,

i write an expression like this sum({$<year={2002},category={mobile}>}this expression have only two values but i need to write more values in this expression but i do not know how to write more values in expression.please tell me out how to write more values in expression.

Regards:

madhu

Re: how to write more values in script?

MK_QSL — Thu, 17 Apr 2014 06:59:03 GMT

Something Like Below

SUM({$<year = {'2002', '2003'}, category = {'mobile','abc'}>}Sales)

Re: how to write more values in script?

ariel_klien — Thu, 17 Apr 2014 07:00:28 GMT

Hi,

you can try:

sum({$<year={2002},category={mobile,Value2,Value3}>}....)

If you want a range of years:

sum({$<year={>2002<2012},category={mobile}>}...)

Hope this will help you.

Ariel

Re: how to write more values in script?

Colin-Albert — Thu, 17 Apr 2014 07:01:16 GMT

Your expression is incorrect, you have not stated which field you are summing, also the category value must be within quotes as the data is text.

sum({$<year={2002},category={'mobile'}>} field_to_sum)

Re: how to write more values in script?

antoniotiman — Thu, 17 Apr 2014 07:03:43 GMT

You want to say

sum({$<year={2002,2003,2004},category={'mobile','pc'}>} sales)

Regrds

Re: how to write more values in script?

Thu, 17 Apr 2014 07:04:55 GMT

thank you ariel

Re: how to write more values in script?

Thu, 17 Apr 2014 07:05:15 GMT

thank you colin

Re: how to write more values in script?

alexandros17 — Thu, 17 Apr 2014 07:14:08 GMT

You are missing something in writeing the expression:

sum({$<year={2002},category={mobile}>} of what?

the correct sysntax is sum({$<year={2002},category={mobile}>} myField)

If you need to add other conditions:

sum({$<year={2002},category={'mobile', 'TV'}, Type={'Flat'}>} myField)

Re: how to write more values in script?

Thu, 17 Apr 2014 13:03:06 GMT

Use can create the set expression Variable and use the variable in the expression.This is the best way to manage the repeatedly changing values in the Set idetifieres.

Re: how to write more values in script?

Thu, 17 Apr 2014 20:59:56 GMT

Re: how to write more values in script?

Thu, 17 Apr 2014 21:50:37 GMT

@madhu - may be you should go through and learn basic set analysis syntax

Set Analysis: syntaxes, examples