Alternate State issue in a straight table

rustyfishbones — Sat, 16 Nov 2024 01:20:09 GMT

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.

Re: Alternate State issue in a straight table

Brett_Bleess — Wed, 04 Mar 2020 22:18:16 GMT

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

topic Re: Alternate State issue in a straight table in QlikView

Alternate State issue in a straight table

Re: Alternate State issue in a straight table