Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

lakwinder
Contributor III

How do i do this expression in the load script

Hi Guys,

How do i do this expression in the load script.

Thanks

Sum({1<PRODUCT={"xxxx"},MONTH={"201410"}>}Value_PQ)

/

Sum (total{1<PRODUCT={"xxxx"},MONTH={"201410"}>}Value_PQ)

-

Sum({1<PRODUCT={"*"},MONTH={"201410"}>}Value_PQ)

/

Sum(total{1<PRODUCT={"*"},MONTH={"201410"}>}Value_PQ)

3 Replies
MVP
MVP

Re: How do i do this expression in the load script

In which context (e.g. chart dimensions) are you using this expression?

If you want to do aggregations in the script, you'll need a GROUP BY clause and use aggregation functions on all fields not listed in that clause. You can filter records in an additional WHERE clause or use conditional functions within the aggregation functions.

sat_tok52
Contributor

Re: How do i do this expression in the load script

Use if condition

Not applicable

Re: How do i do this expression in the load script

Where condition will work. You could also use "match" in use dimension to pick the field you want

Community Browser