Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor III

How to compute sum(sales) when user click on Diamension = Coy ?

Hi All

I have Table 1 , it can display correct report when user click on Diamension = Brand , Product Class , Desc .

But when user click on Diamension = Coy , Table 1 display wrong report.

So when user click on Company , i want to table 2 data display at Table 1.

I try the expression below :-

if(

$(ColumnDim10)

='5 COY'

,SUM(sales)

,SUM(C_ONHAND_AMT)

))

it display null value.

Paul

2 Replies
gautik92
Valued Contributor III

Re: How to compute sum(sales) when user click on Diamension = Coy ?

can yu send sample qvw?

paulyeo11
Valued Contributor III

Re: How to compute sum(sales) when user click on Diamension = Coy ?

Hi All

Enclosed my QV doc.

Paul