# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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.

1 Solution

Accepted Solutions
MVP

## Re: ignore Time dimension on a chart

Try this

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

2 Replies
MVP

## Re: ignore Time dimension on a chart

Try this

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

MVP

## Re: ignore Time dimension on a chart

Or this

Sum(Sales)/Sum(TOTAL Purchases)