Set Analysis Query

[Anonymous]

Hi

I’m really new to Qlik Sense and am having trouble getting a simple set analysis to work.  I have a qvd of transactions that have columns including ‘Amount’ and ‘Actual_Flag’.  I want to return the amount where the actual flag is ‘A’ but although the expression is accepted by the expression editor I am getting an invalid dimension indicator.

SUM(${<ACTUAL_FLAG={'A'}>}AMOUNT)

Any advice would be appreciated

Thanks

Diane

[Ivan_Bozov]

If you use AdBlock, disable it for qlik.com as it blocks some of the buttons on the site.

[Anonymous]

Hi Sunny

Thanks for the advice, I've logged in and can see the reply option on the left but still no 'Correct' button.  Sorry I know this should be a simple thing but it's proving difficult!

[Anonymous]

Hi Ivan

I've disabled the adblock but no further forward. 

[sunny_talwar · Accepted solution]

You are now in your inbox and not on the main thread.... click on this link which will take you to the main thread

Re: Set Analysis Query

[Anonymous]

Thanks Sunny, I can now stop tearing my hair out!  I had just assumed that I went in via the inbox.  What's the best way to go to the main thread each time?

[Anonymous]

Sorry, you can ignore my last question.  I've found the answer , go via view profile, through on of the quick start links.  Thanks again for your help and patience.