Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Is this feasible in QlikSense?

Hello All,

I have a peculiar requirement which is described below. Could anyone help with your inputs/suggestions.

Requirement: I am looking to have two time series overlaying each other on one chart. Requirement is to show meetings from one quarter and the sales from the following quarter to be on top of each other.  In other words, did the work I did last quarter impact sales this quarter.

Regards,

Kishore

1 Reply
swuehl
MVP
MVP

Maybe use a calculated dimension like

=daynumberofquarter( DateField)

and two expressions, something along these lines

=Count( If( InQuarter( DateField, Today(), -1), Meeting))

=Sum( If( InQuarter( DateField, Today() ) , Sales))

you may also use set analysis to restrict your records to specific quartes per expression.