Skip to main content
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
Showing results for 
Search instead for 
Did you mean: 
Master II
Master II

Alternate State issue in a straight table


I have a staright table were i am calculating the following expression NUM(MAX({altDate}[Stat Week])-MAX([Stat Week])), all other expressions are comparing a from date and to date and they work fine, i also tried using the following

NUM(Week(MAX({altDate}[Stat Date]))-WEEK(MAX([Stat Date]))).

So the straight table displays the total but not the lines level detail and its confusing as hell.








Labels (1)
1 Reply
Former Employee
Former Employee

You will have to provide some additional information on this one, no idea what we are trying to help you solve here.  Probably the most helpful thing would be your expected output and potentially the input records to be able to tell what it is we are trying to do here.  


To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.