Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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.



1 Reply

Re: Is this feasible in QlikSense?

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.

Community Browser