topic Re: Alternate states-qlikview in QlikView

Alternate states-qlikview

Tue, 02 Sep 2014 05:16:23 GMT

Hi,

I had a case where i need to compare two product list boxes and display the result in line chart. I acheived this using altrenate states. But my problem here is the charts and list boxes should be conditionally enabled based on selection in another list box.

For example

Assume list box as below.

Products

Executive

If products is selected, everything related to them should be displayed(2 list boxes and charrt).Similar to executive. Please help me to acheive this

Thanks

Kausalya

Re: Alternate states-qlikview

tresB — Tue, 02 Sep 2014 05:20:21 GMT

Check this attached qvw.

Re: Alternate states-qlikview

tresB — Tue, 02 Sep 2014 05:30:03 GMT

Try to share a qvw with sample data.

Re: Alternate states-qlikview

Tue, 02 Sep 2014 06:03:30 GMT

Try this QVW may help you

In this the chart is enabled with set analysis.

Re: Alternate states-qlikview

Tue, 02 Sep 2014 06:30:07 GMT

Kausalya,

Can you clarify a bit more

what is the exact requiremetn

do u require Alternate States or Filter condition

do provide some more info

Re: Alternate states-qlikview

Tue, 02 Sep 2014 06:32:51 GMT

alternate state for comparison of products/executives and filter for enabling/disabling of list boxes and charts

Re: Alternate states-qlikview

Tue, 02 Sep 2014 06:51:24 GMT

For listbox enabling / disabling;

1) Listboxes should not be disabled, because as the listboxes acts as filteration and selection purpose

(List boxes can be disabled/enabled)

2) Charts can be disabled based on the conditions

charts->properties_>presentation->Show->Conditional->GetselectedCount(listboxnaemyouareusing)>0

if the user made one selection the chart will be enabled with the above codition

This may help you

Re: Re: Re: Alternate states-qlikview

tresB — Tue, 02 Sep 2014 06:54:33 GMT

Perhaps, you are struggling with alternate sate reference for enabling condition. If so, try like:

=Only({<selections=$::selections>}selections)='By Product'

Note: $:: refers the default state.