topic Re: SET expression with variables in QlikView

SET expression with variables

Tue, 21 Oct 2014 08:55:32 GMT

Hi all.

I need to use set expression with value variable.

I don't know how i can write this formula

For example i have variable vSALES

it is SALES with documents 1, 2, 3

sum(<documents = {1,2,3}>}Sales

- sum(<documents = {4}>}Sales

This vSALES

I want to use this vSALES for anather SET

for example

sum(<year = {2014}>}vSALES ???? How to write expression

Re: SET expression with variables

senpradip007 — Tue, 21 Oct 2014 08:59:32 GMT

Try like:

Sum({<year={2014}, document={1,2,3}>} Sales)

Re: SET expression with variables

MK_QSL — Tue, 21 Oct 2014 09:01:13 GMT

define

vSALES = documents = {1,2,3}-{4]

Now use as below

SUM({<vSALES, year = {2014}>}Sales)

Re: SET expression with variables

Tue, 21 Oct 2014 09:05:22 GMT

OK its good, but i want with variables becouse my formula for sales have o lot of many part and add 2 set in another for this parts it is not good idea

Re: SET expression with variables

senpradip007 — Tue, 21 Oct 2014 09:08:37 GMT

Can you upload sample app?

Re: SET expression with variables

Tue, 21 Oct 2014 09:30:04 GMT

Sorry but real file not, but you can created any file for this situation examples, just i want how use variables in finish set expression.

Re: SET expression with variables

Anonymous — Tue, 21 Oct 2014 10:31:07 GMT

Hi try something like this:

In Expr:

Sum($(vCondition) Sales)

and in Variables

vCondition

{<year={2014}, document={1,2,3}>}

Re: SET expression with variables

upaliwije — Tue, 21 Oct 2014 11:03:51 GMT

sum(<year = {2014}>}$(=vSALES)) How to write expression

Re: SET expression with variables

Anonymous — Tue, 21 Oct 2014 11:22:29 GMT

I tried, this is working fine

=sum(<year = {2014}>}vSALES)