Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
Not applicable

pls help

I have Sum(saleQty) in my chat column expression but i want to get only "retail" saleQty. how to use Sum(saleQty) and retail in set analysis to do the task. thanks

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: pls help

Sum({<Type = {'retail'}>}saleQty)


Here type is the dimension name which contains retails..

You can replace as per your field name

View solution in original post

5 Replies
Highlighted
MVP
MVP

Re: pls help

Sum({<Type = {'retail'}>}saleQty)


Here type is the dimension name which contains retails..

You can replace as per your field name

View solution in original post

Highlighted
Not applicable

Re: pls help

Hi Dushan

Sum({<YourFieldName={'retail'}>} saleQty)

best regards

chris

Highlighted
er_mohit
Honored Contributor II

Re: pls help

try this

Sum(<Fieldname='retail'>saleQty)

or try this

Sum({<Fieldname= {'retail'}>}saleQty)

Highlighted
Not applicable

Re: pls help

thanks both of u

Highlighted
Not applicable

Re: pls help

another thing, i want to get retail and wholesale contribution to another column. In my chart I have retail sale and whole sale in two rows.

as an example, if my retailsale=500 and Wholesale=1000, i want to get the contribution as retail contribution=(500/(500+1000))*100 automaticaly and same as whole sale contribution. how can I do this in a chart expression?