Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How to filter only sales change are more then 0% ?

Hi All

I have a table which display CY and LY sales and i also have a 3 col which display the sales change %.

Now i like to make my table only list those sales up customer.

Hope some one can advise how to achieve this ?

1 Solution

Accepted Solutions
phaneendra_kunc
Valued Contributor III

Re: Re: How to filter only sales change are more then 0% ?

See attached.

9 Replies
phaneendra_kunc
Valued Contributor III

Re: How to filter only sales change are more then 0% ?

So you don't want to display any -ve % values?

Not applicable

Re: How to filter only sales change are more then 0% ?

So that sales person can take action on those sales increase customer. So that sales can further increase. And still want to view the % up.

Sent from Samsung Mobile

iktrayanov
Contributor III

Re: How to filter only sales change are more then 0% ?

Use % increase as your first expression and use dimension limits by first expression.

phaneendra_kunc
Valued Contributor III

Re: Re: How to filter only sales change are more then 0% ?

See attached.

Not applicable

Re: How to filter only sales change are more then 0% ?

Hi sir

Thank you very much. Can you pls give me some example ?

Sent from Samsung Mobile

Not applicable

Re: How to filter only sales change are more then 0% ?

Hi sir

Yes this is what i need. But i am not able to figure out how you do it. can you share with me ?

Paul

Not applicable

Re: How to filter only sales change are more then 0% ?

Hi All

Phaneendra Provide me a soluition , which is very good. but i am not sure how he filter only display +Ve % value , can some one tell me ?

iktrayanov
Contributor III

Re: How to filter only sales change are more then 0% ?

I think he changed your expressions to only calculate when sales for the current period are more than the sales for the previous period. Take a look at your expressions. Hope that helps.

Not applicable

Re: How to filter only sales change are more then 0% ?

hI iVAN

He very smart.

Community Browser