Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vanderson009
Contributor

Percentage in Qlik Sense

In table chart i have to calculate difference in percentage.

In table chart i have year as dimension then in second column i am calculating sum(Sale) for May month, in third column i am calculating sum(Sale) for Apr month, and at fourth column i need to calculate percentage difference.

2 Replies
MVP
MVP

Re: Percentage in Qlik Sense

What are the expression for Apr and May Sales?

DavidŠtorek
Contributor III

Re: Percentage in Qlik Sense

Hi,

and your question?

You probably want something like that:

(sum({1<Month={'May'}>}Sales)-sum({1<Month={'April'}>}Sales))/sum({1<Month={'April'}>}Sales)

Community Browser