topic Re: How to use {} in script. in QlikView

How to use {} in script.

ashishpalkar — Tue, 15 Dec 2015 20:11:18 GMT

Hi There

I am using below set analysis in Chart Table, i want to use this at script level.

any suggestions?

IF(Country='US','N/A',sum({$<MNTH={'0'}>} [Revenue]))

thanks in advance,

Re: How to use {} in script.

swuehl — Tue, 15 Dec 2015 20:21:53 GMT

Your set analysis will only filter MNTH field with a fixed value, but the aggregation will still regard other user selections.

How will you handle this in the script?

Re: How to use {} in script.

maxgro — Tue, 15 Dec 2015 20:21:54 GMT

Do you want a sum of Revenue by Country (excluding US) ?

Re: How to use {} in script.

ashishpalkar — Tue, 15 Dec 2015 20:29:55 GMT

Yes , and month can be from 0 to 12.

Re: How to use {} in script.

MarcoWedel — Wed, 16 Dec 2015 00:15:47 GMT

please post sample data and expected result.

thanks

regards

Marco

Re: How to use {} in script.

MayilVahanan — Wed, 16 Dec 2015 06:02:32 GMT

Hope country, revenue and month field are available in same table.

If so, try like this

Load *,

IF(Country <> 'US' and MNTH = 0,[Revenue], 0) AS MonthZeroNonUSRevenue,

IF(Country <> 'US' and MNTH = 0,1, 0) AS MonthZeroNonUSFlag;

Exp:

=Sum({<MonthZeroNonUSFlag ={1}>}Revenue)

=Sum(MonthZeroNonUSRevenue)

Else, please post sample data and required output.

Re: How to use {} in script.

Anonymous — Wed, 16 Dec 2015 06:08:23 GMT

If Country, Month, Revenue field are in same table, then this should work:

at script table:

IF(Country='US','N/A',if(Month='0', sum(Revenue)))

Re: How to use {} in script.

Wed, 16 Dec 2015 06:13:34 GMT

Try This :

IF(Country='US','N/A',if(Month='0',Revenue)) as Revenue1

then summation you can do on the dashboard as sum(Revenue1)

Thanks

Khushboo

Re: How to use {} in script.

ahmar811 — Wed, 16 Dec 2015 06:17:55 GMT

hi Ashish

try this

IF(wildmatch(Country,'US')=0,'N/A',if(Month='0', sum(Revenue)))

hope this help you

Regards

Ahmar

Re: How to use {} in script.

tripatirao — Wed, 16 Dec 2015 07:02:49 GMT

As per my knowledge we can't use set expression in qlikview scripting.

Try something like using groupby clause.

or you can follow what khushboo suggested.

Regards

Tripati

Re: How to use {} in script.

ashishpalkar — Wed, 16 Dec 2015 17:24:02 GMT

Thanks for for your helpful response.

Khushboo's suggestion is best fit and working fine...