topic Show Comparison month value in QlikView

Show Comparison month value

dsharmaqv — Wed, 25 Nov 2020 16:16:04 GMT

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

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 — Tue, 24 Jan 2017 13:16:43 GMT

You want at front end or back end?

MK_QSL — Tue, 24 Jan 2017 13:21:47 GMT

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

Country,

Status

FROM

(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 — Tue, 24 Jan 2017 13:33:10 GMT

Can I get a sample app please

MK_QSL — Tue, 24 Jan 2017 13:57:48 GMT

Enclosed..