topic Re: Alternate state with Other Filterbox selction in QlikView

Alternate state with Other Filterbox selction

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I’m trying to use Alternate State on Straight Table chart, but Straight table should also respond to other Lists boxes.

e.g.,

My Detail Straight table has Status Listbox (which is Alternate State) and this Straight table should also respond to other list boxes like Country, Month, etc.

I have used non aggregated columns (Dimensions) in the Expression.

Please help!

Thank you

Re: Alternate state with Other Filterbox selction

sunny_talwar — Mon, 08 May 2017 18:48:25 GMT

Would you be able to share a sample to show what you are trying to do?

Re: Alternate state with Other Filterbox selction

Mon, 08 May 2017 19:07:22 GMT

Hi, Thanks for the response.

Bottom right 'Dim1' has alternate state and linked with Table 2.

Table 2 is a Straight table with Dimensions as expression.

I'm expecting Table 2 should respond to Dim 1 (Alternate State) and also to Dim 3 (inherited)

Re: Alternate state with Other Filterbox selction

sunny_talwar — Mon, 08 May 2017 19:25:03 GMT

So for instance if you select X in Dim3 and A in Dim1, you would want to see only 1 row where Dim1 = A and Dim3 = X?

Re: Alternate state with Other Filterbox selction

Tue, 09 May 2017 01:15:29 GMT

Yes, if I select X in Dim3 and A in Dim1, you would want to see only 1 row where Dim1 = A and Dim3 = X

Re: Alternate state with Other Filterbox selction

sunny_talwar — Tue, 09 May 2017 11:15:39 GMT

Check the attached

Re: Alternate state with Other Filterbox selction

Tue, 09 May 2017 14:10:27 GMT

Fantastic, Thank you so much!

Regards, Sri