topic Alternate States in QlikView

Alternate States

hkapadia — Thu, 11 Sep 2014 17:56:54 GMT

I have 2 multi boxes for 2 dates with alternate state for each.

When I select a date from the box, I want to show that date & the corresponding amount in the columns of a straight table. I'm able to show the amount using the expression sum({[Date1]} Amount) where Date1 is the name of the alternate state. However, I'm not able to show the selected date value in the column of a straight table. I'm trying to use an expression =GetFieldSelections({[Date1]} Date) but it doesn't work.

Please help.

Re: Alternate States

vgutkovsky — Thu, 11 Sep 2014 18:48:51 GMT

Try something like date(only({Date1} Date))

Getfieldselections is not a function that you can use alternate states with.

Regards,

Vlad

Re: Alternate States

hkapadia — Thu, 11 Sep 2014 18:54:35 GMT

Thanks Vlad for a quick response.

That worked as I wanted.

Re: Alternate States

hkapadia — Fri, 19 Sep 2014 19:23:55 GMT

Vlad,

As you mentioned, I was able to display amount based on 2 selected dates in the straight table.

Another problem I have is that if I try to select any dimension value in the straight table none of the other charts/tables that I have are filtered based on that dimension & the 2 selected dates. Is that because of the alternate states I'm using on the dates? Is there a way around that?

Thanks

Hitesh

Re: Alternate States

vgutkovsky — Fri, 19 Sep 2014 21:12:32 GMT

By the way, I should mention that, as of 11.20 SR8, you can use alternate states with functions like getfieldselections.

I'm assuming your straight table is in the default state? If so, and depending on what exactly you want to do, you might be able to just use set multiplication. For example: date(only({Date1*$} Date))

Vlad

Re: Alternate States

hkapadia — Wed, 24 Sep 2014 21:20:15 GMT

Vlad,

Thanks for your reply but I'm confused. My straight table is in the default state but doesn't filter based on the other dimension that I select from the table.

Hitesh

Re: Alternate States

vgutkovsky — Wed, 24 Sep 2014 22:04:54 GMT

Can you post one of your straight table expressions?

Vlad