Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

danielco223
New Contributor III

Need If statement to calculate based on dimension to the left

Hi,

I have a table that I need to calculate based on the dimension on the left of the table. The two dimensions are from an inline load I am doing called "Grouping". Below is the table:

5-23-2018 2-29-15 PM.jpg

I need the measuers for Orders(000), Sales(000) and PTQ calculate based on the dimension being MTD or Prior Day. Below is the analyisis I was using.

if(Grouping='MTD',

Sum({<

[Fiscal - Flag Current Date]='Y'

>}

[Amount - Ordered USD])

,

Sum({<

[Fiscal - Flag Current PTD]='Y'

>}

[Amount - Ordered USD]))

However, this is just returning zeros. How can I get this measure to identify and consider the dimension in the corresponding column?

Thanks!

1 Solution

Accepted Solutions
Ivan_Bozov
Valued Contributor

Re: Need If statement to calculate based on dimension to the left

You are missing the curly brackets in the set statements: {'Y'}

1 Reply
Ivan_Bozov
Valued Contributor

Re: Need If statement to calculate based on dimension to the left

You are missing the curly brackets in the set statements: {'Y'}

Community Browser