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

Alternate State issue in a straight table

Hi,

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.

 

qlik_screenshot.png

 

 

 

 
 
 

 

Labels (1)
1 Reply
Brett_Bleess
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.  

Regards,
Brett

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.