topic Re: Conditional display of values in QlikView

Conditional display of values

Mon, 31 Mar 2014 06:53:51 GMT

Hello everyone,

New Query:

I have created two multi boxes of 'Year' (it can also be a list box) and I want to make independent selections from both which I achieved by creating alternate states.

However now the issues:

If I choose Year = 2005 in multibox 1 then i want that the values to be displayed on multibox 2 should be greater than 2005.

The values to be displayed in Multibox 2 should be always greater than the selected field value in Multibox 1.

Re: Conditional display of values

alexandros17 — Mon, 31 Mar 2014 07:08:23 GMT

You may add a trigger to the field (Settings -> document properties -> triggers)

Re: Conditional display of values

Mon, 31 Mar 2014 07:16:30 GMT

Can you please elaborate..

Re: Conditional display of values

ashwanin — Mon, 31 Mar 2014 07:32:41 GMT

Alessandros suggestion will work for you. Please use this in your qvw.

Re: Conditional display of values

Mon, 31 Mar 2014 08:03:47 GMT

Hi,

Pls go through the attached qvw.

Trigger is set up in Document Properties.

Thanks,

Prabhu

Re: Conditional display of values

Mon, 31 Mar 2014 09:29:22 GMT

ok I will try to explain further...

Suppose first listbox is in state 1 and second listbox is in state 2

now if i select 2005 in first listbox i want that second listboxes should display values greater than 2005 and they should also be available for selection.

if i want to calculate Difference of Sales(per say) of 2005 and 2008 so i would select the years separately from two list boxes and I also need to make sure that the second listbox only displays values greater than the selected value in first listbox.

I hope this explains the issue

Re: Conditional display of values

Mon, 31 Mar 2014 10:26:56 GMT

Did you go through the attached qvw?

I believe what you expect is implemented.

Thanks,

Prabhu

Re: Conditional display of values

Mon, 31 Mar 2014 10:30:24 GMT

The value in the second list box keeps changing... I want to make a selection in the second listbox as well. The only criteria is that the user should not be able to see the year values less than the first selection

Re: Re: Conditional display of values

Mon, 31 Mar 2014 10:42:43 GMT

Got it.

Chk this.

Thanks,

Prabhu

Re: Conditional display of values

Tue, 01 Apr 2014 05:18:41 GMT

Ya it is... Thank you so much

Re: Conditional display of values

Sat, 28 Jun 2014 14:36:12 GMT

Hi,

I want to compare the values of two list box in single table. i am thinking of doing this using alternate state..

let me explain you, I have two year list box, user can select two different values in list box to compare.

i want to show sum of amount in single table for values from the list boxes.

could some please help me with this.

Re: Conditional display of values

Mon, 30 Jun 2014 12:43:07 GMT

Any one can help with some other approach.