topic Line chart without measure functions in expression in QlikView

Line chart without measure functions in expression

qlikwiz123 — Sat, 16 Nov 2024 17:51:07 GMT

I am trying to create a line chart with two dimensions and one expression.

Dimensions are WeekStart(Date) and Type

Expression is NumberX * [Total Value]

This gives me No data to display. But writing my expression as Sum(NumberX * [Total Value]) gives the line chart. But doing a Sum gives incorrect values.

How do I use my NumberX * [Total Value] in Expression without using Sum or Count or any other aggregating measure function?

Re: Line chart without measure functions in expression

dplr-rn — Mon, 09 Nov 2020 23:16:23 GMT

i would check your values.

what this generally indicates that there is more than 1 value of NumberX or/and [Total Value] for weekstart and type combination.

my educated guess is this

i think you have data like below


Date	Value
2-Nov-2020	10
3-Nov-2020	20
4-Nov-2020	5
9-Nov-2020	30

so what happens when you have a dimension WeekStart(Date) is you get 3 values for 1-Nov-2020 (10,20,5)

this will not work.

And it will need some aggregation (sum or otherwise).

Share some sample data and example of desired output

Re: Line chart without measure functions in expression

MayilVahanan — Tue, 10 Nov 2020 02:59:22 GMT

Hi @qlikwiz123

Try like below

Sum(NumberX) * Sum([Total Value])

If both fields are in same table, you can try Sum(NumberX * [Total Value]).