topic Re: Alternate States Issue, Driving me crazy! in QlikView

Alternate States Issue, Driving me crazy!

rustyfishbones — Sat, 16 Nov 2024 01:19:53 GMT

Hi All,

I have the following issue, when I use option 1 below in a straight table, it returns no result, I have 2 date listboxes, one is inherited state and the other has an alternate state of altDate

1. =(WEEK(DATE(MAX({altDate}[Stat Date])))-WEEK(DATE(MIN([Stat Date]))))

if I select all the dates required from the inherited date listbox using option 2. below it works, but thats not how i want them to select

2. =(WEEK(DATE(MAX([Stat Date])))-WEEK(DATE(MIN([Stat Date]))))

Thanks in advance

Re: Alternate States Issue, Driving me crazy!

rustyfishbones — Thu, 06 Feb 2020 18:20:38 GMT

@Gysbert_Wassenaar have you seen a similar issue to this before?

Re: Alternate States Issue, Driving me crazy!

sunny_talwar — Thu, 06 Feb 2020 18:39:11 GMT

What exactly are you trying to do? Select Max Stat Date from altDate and subtract Min Stat Date from inherited state? Also, where are you using this chart? In a table or text box object?

Re: Alternate States Issue, Driving me crazy!

rustyfishbones — Thu, 06 Feb 2020 19:49:13 GMT

I am using it in an expression in a straight table, I have 2 date list boxes one list box is inherited state the other is altdate.

in list box 1 I select 25/09/2019 and in list box 2 I select 21/12/2019, there are 12 weeks between those dates, when I place the expression in a text object it works, but when I use it in a straight table I get a - not even a zero, I have other expressions in the straight table that work perfectly fine, but the one I post containing altDate returns nothing in the straight table

Re: Alternate States Issue, Driving me crazy!

sunny_talwar — Thu, 06 Feb 2020 19:51:26 GMT

Try this

=Week(Max(TOTAL {altDate} [Stat Date])) - Week(Min(TOTAL [Stat Date]))

Re: Alternate States Issue, Driving me crazy!

rustyfishbones — Thu, 06 Feb 2020 21:50:23 GMT

That worked, thank you Sunny