Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

How to insert condition to none SET expression ?

Hi All

I have below expression :-

sum(DISTINCT  NET_PROFIT_A_TAX_C)

/

sum(DISTINCT  REVENUE_C)

May i know how to insert the below condition to  above expression :-

COMPETITOR = {'WAGO', 'iTDS')

Paul

1 Solution

Accepted Solutions

Re: How to insert condition to none SET expression ?

May be like this:

Sum(DISTINCT {<COMPETITOR = {'WAGO', 'iTDS'}>} NET_PROFIT_A_TAX_C)

/

Sum(DISTINCT {<COMPETITOR = {'WAGO', 'iTDS'}>} REVENUE_C)

2 Replies
paulyeo11
Valued Contributor II

Re: How to insert condition to none SET expression ?

my QV Doc

Re: How to insert condition to none SET expression ?

May be like this:

Sum(DISTINCT {<COMPETITOR = {'WAGO', 'iTDS'}>} NET_PROFIT_A_TAX_C)

/

Sum(DISTINCT {<COMPETITOR = {'WAGO', 'iTDS'}>} REVENUE_C)

Community Browser