topic Re: using set analysis in each expression or limit the dimension? and how? in QlikView

using set analysis in each expression or limit the dimension? and how?

chriscools — Tue, 14 Feb 2017 15:53:28 GMT

Hello,

i want to make a table (or pivot table) with a few dimensions:

Skucode

Productstatus

Description

and with sevel expressions to calculate:

- sum of sales outstanding in € and pieces

-sum of sales for the past 3 years (also in € and pieces)

-current stock level

-current purchase in € and pieces

-...

But i only need it for the Skucodes where Productstatus is equal to Active and Liquidation, and not for the other Productstatuses.

i wanted to make it using set analysis for each expression, but is there a way i can easily limit the dimension Skucode to only show the 2 statusses and not needing to repeat it in al of the expressions?

perhaps it more efficient to do it only once in the dimension and not in each expression?

grtz,

Chris

Re: using set analysis in each expression or limit the dimension? and how?

Tue, 14 Feb 2017 15:58:08 GMT

like this u want

use dimension:

only({<Productstatus ={'Active','Liquidation'}>}Skucodes )

Re: using set analysis in each expression or limit the dimension? and how?

sunny_talwar — Tue, 14 Feb 2017 16:00:12 GMT

I guess efficiency wise, I will create a flag in the script and use set analysis, but I guess if you have 100 expressions, may be it might be easier to make changes, but even then I would assume set analysis to give better performance.