Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Luminary
Luminary

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

vizmind.eu

View solution in original post

1 Reply
Ivan_Bozov
Luminary
Luminary

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

vizmind.eu