Show Comparison month value

[dsharmaqv]

Hi I have a requirement where I have to display current month and comparison month value side by side.

Month	Country	Status
Jan	IND	High
Jan	AUS	High
Jan	UK	Med
Jan	US	Low
Dec	IND	Low
Dec	AUS	High
Dec	US	High

Output

Month	Country	Current Month Status	Comparison Month Status
Jan	IND	High	Low
Jan	AUS	High	High
Jan	UK	Med	-
Jan	US	Low	High

Note: Current month and Comparison Month both are static and can be selected by user

[MK_QSL]

You want at front end or back end?

[MK_QSL]

LOAD Date#(Month,'MMM') as Month,

     Country,

     Status

FROM

[https://community.qlik.com/thread/247333]

(html, codepage is 1252, embedded labels, table is @1);

Create a Straight Table

Dimension

=Month(Today())

Country

Expression

Only({<Month = {'$(=Month(Today()))'}>}Status)

Only({<Month = {'$(=Date(Month(Today())-1,'MMM'))'}>}Status)

[dsharmaqv]

Can I get a sample app please

[MK_QSL · Accepted solution]

Enclosed..