Percentage in Qlik Sense

[vanderson009]

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.

[sunny_talwar]

What are the expression for Apr and May Sales?

[DavidŠtorek]

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)