topic Re: Listbox in QlikView

Listbox

Wed, 29 Aug 2012 20:20:18 GMT

Hello,

I need a help with a listbox.

variables:

* VarComp = IF (GETSELECTEDCOUNT (Year_Sales) = 2, COUNT (DISTINCT Month_Sales & Year_Sales))

* = YearSelect GETSELECTEDCOUNT (Year_Sales)

I put the following expression in the listbox:

* IF (YearSelect = 2,

IF (AGGR (COUNT (DISTINCT Month_Sales & Year_Sales) cod_store) = VarComp, 'Comparable', 'not comparable')).

This code compares whether there sales in the months and years selected.

When I click once on comparable he brings me the correct value of sales in stores then I click no where comparable QlikView also gives me the correct value is not comparable, but the listbox the value of comparable disappears, leaving only the value of not comparable value when I click again on the Qlikview not show comparable values of the two listbox that is, the value of comparable appears selected, and the result is the chart wrong.

thank you

Re: Listbox

sebastiandperei — Thu, 30 Aug 2012 01:56:39 GMT

Hi,

Could you send a reduced copy?

Re: Listbox

Thu, 30 Aug 2012 12:21:28 GMT

Sebastian Pereira,

Attached is an example of my code.

First click the value "Comparable" in the listbox and watch the values of table sales, now look what happens when you click "Not Comparable", note that the listbox selects the value "Comparable" sales table and returns the value "Not comparable. "

In the full version is even more serious because the value "Comparable" disappears when I click on the listbox value "Not Comparable."

When I click again on "Not Comparable" to deselect the value "Comparable" reappears only selected and that the values of the table shows sales as if nothing is selected in the listbox.

Re: Listbox

sebastiandperei — Thu, 30 Aug 2012 18:21:10 GMT

Which fields do you want to select with this listbox?

Tell me what you need. What means Comparable or Not Comparable?

(por tu nombre parece que hablás español, si es en español mejor! de dónde sos?)

Re: Listbox

whiteline — Sat, 01 Sep 2012 18:07:57 GMT

You should just use {1} set to ignore selections:

=IF(AnoSelect = 2,IF(AGGR(count({1} DISTINCT MONTH_SALE&YEAR_SALE),STORE)=VarComp,'comparable','not comparable'))