Bar chart in qliksense

[suvechha_b]

How to get the below report in qliksense ?

How to calculate premium for 2 years and display in monthwise.

See sample image.

Thanks

[jfkinspari]

Use Month number as dimension
Use two expressions that each calculates the premium for each year using set analysis

[chrislemm · Accepted solution]

Choose a barchart. Add the month as dimension (num(month) for the numbers instead of Jan. Feb. etc.). Add a measure:

sum( {<Year = {'2019'}>}sales)

and another:

sum( {<Year = {'2018'}>}sales)

This is called set analysis (you'll find a lot of ressources in the community). Basically it pre-filters your measure.

Replace the years with some kind of year(today()) or inyeartoday/lastyeartoday logic if you don't want to change the expressions every year.

Greetings.

[suvechha_b]

Thanks the expression work. But I am struggling to get this below

and sorting of months in qliksense. Please assist.

My output results is below.

[chrislemm]

Go to sheet edit mode -> select your barchart -> options (right side) -> Sorting -> Sort Month numeric.