Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ziabobaz
Contributor II

ignore Time dimension on a chart

Hi

I have a line chart

Dimension: WEEK

Measure: sum(Sales)/sum({<week=>}Purchases)

My intention is that the chart shows Sales for the given week, divided by TOTAL purchases which were made, regardless of the week. So, in fact, the denominator will always be the same.

The above formula does not work.

Please, correct

1 Solution

Accepted Solutions

Re: ignore Time dimension on a chart

Try this

Sum(Sales)/Sum(TOTAL {<week=>}Purchases)

2 Replies

Re: ignore Time dimension on a chart

Try this

Sum(Sales)/Sum(TOTAL {<week=>}Purchases)

Re: ignore Time dimension on a chart

Or this

Sum(Sales)/Sum(TOTAL Purchases)

Community Browser