Listbox

[#1]

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

[sebastiandperei]

Hi,

Could you send a reduced copy?

[#3]

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.

[sebastiandperei]

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?)

[whiteline]

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'))