Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

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
Specialist III
Specialist III

can yu send sample qvw?

paulyeo11
Master
Master
Author

Hi All

Enclosed my QV doc.

Paul