# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor II

## Comparison between Month Sections

Hello,

I currently have a KPI showing the number of standards and changes as you select a month. But now I want to be able to show the differences between to months, so if I select February and March I want to show that there is a difference of 14. How would I be able to do that? I'm not really sure.

Currently, this is my expression to show the current amount of standards:

Count({<[UMHC SYSTEM]={'100%'},[EC-LS-EM]= {'EC'}>} [UMHC SYSTEM])/16

Thank you!

1 Solution

Accepted Solutions
MVP

## Re: Comparison between Month Sections

May be like this

For March

Count({<[UMHC SYSTEM]={'100%'},[EC-LS-EM]= {'EC'}, Month = {"\$(=MaxString(Month))"}>} [UMHC SYSTEM])/16

For Feburary

Count({<[UMHC SYSTEM]={'100%'},[EC-LS-EM]= {'EC'}, Month = {"\$(=MinString(Month))"}>} [UMHC SYSTEM])/16

9 Replies
MVP

## Re: Comparison between Month Sections

May be like this

For March

Count({<[UMHC SYSTEM]={'100%'},[EC-LS-EM]= {'EC'}, Month = {"\$(=MaxString(Month))"}>} [UMHC SYSTEM])/16

For Feburary

Count({<[UMHC SYSTEM]={'100%'},[EC-LS-EM]= {'EC'}, Month = {"\$(=MinString(Month))"}>} [UMHC SYSTEM])/16

Contributor II

## Re: Comparison between Month Sections

Hey Sunny!

That works great! But let me ask you once I have more months how would that work? Would I be able to select like the month March and May to see the difference?

MVP

## Re: Comparison between Month Sections

Yes, but if you select more than 2 months, lets say March, April and May... then it will show you difference between May and March... April will be ignored

Contributor II

## Re: Comparison between Month Sections

Ok perfect, that could work.

If I wanted to be able to pick more than 2 months what would I have to do?

By the way, thank you as always for helping!

MVP

## Re: Comparison between Month Sections

What would you want to see if you select more than 2 months?

Contributor II

## Re: Comparison between Month Sections

I guess I wouldn't need to see that as a KPI, but better as a graph maybe. So I think this will work for now.

Contributor II

## Re: Comparison between Month Sections

Another question, on the label for this KPI could I have it display the month that is chosen? So if I wanted it to display the min month, how can that be done?

MVP