Straight table showing sales by quarter

[martin_hamilton]

why can something so simply cause me so much frustration!

I want to show a straight table by salesperson split by a summary of sales broken by quarter.

I have edited my script to create a quarter value so was expecting to set an expression which took this into account e.g.

=Sum( {$<[Invoice_Year_Quarter] = {'2016-Q1'}>}Subs_Invoice_Amount )

but it doesnt seem to want to work! what am I doing wrong?

I know the formula is correct as I have used it in a text box...any ideas please

Thanks

Martin

[Digvijay_Singh]

You should use quarter as second dimension, Qlikview will do the rest of the job for you.

[marcus_sommer · Accepted solution]

Maybe the association between your quarter, the amount and your salesperson isn't correct. What should be the correct result? It would be helpful if you provide some data and your expected values.

- Marcus

[martin_hamilton]

Hi Marcus I think this is probably the case when i look at the table structure. I will raise another discussion around joining columns from a previously loaded file to create a join. Thanks.