topic Holding Data instead of empty in QlikView

Holding Data instead of empty

jagannalla — Tue, 05 Jul 2011 04:53:41 GMT

Hi,

I've a 2 listboxes with 2 fields(Group,Group1). OnActiveSheet i written a macro to select all fields of data in listbox.

Code is:

Sub ActivateSH12

set lb= ActiveDocument.GetSheetObject("LB455")

lb.SelectPossible

set lb= ActiveDocument.GetSheetObject("LB456")

lb.SelectPossible

End Sub

- I taken a variables v1,v2 to store all selection of listboxes in button action as v1= GetFieldSelections(Group,',',50) & v2= GetFieldSelections(Group1,',',50).

- Upto here is fine and it is working to store all data into variables. But if i clear all listboxes and when i click the button the variables are holding all data of listboxes instead of empty.

Holding Data instead of empty

kaushiknsolanki — Tue, 05 Jul 2011 06:29:52 GMT

Hi,

Its working properly at my side.

Can you please upload the qvw file.

Regards,

Kaushik Solanki

Holding Data instead of empty

jagannalla — Tue, 05 Jul 2011 09:40:33 GMT

The problem is appearing when we have expression in the listbox.

For Eg:

- I've 2 listbox with fields F1,F2.

- I'm taking the expression in F2 as =if(F1='A',F2) i.e F1 has data A.

Holding Data instead of empty

kaushiknsolanki — Tue, 05 Jul 2011 09:51:01 GMT

Hi,

Pls. upload the qvw file. That will help me to understand the problem properly.

Regards,

Kaushik Solanki

Holding Data instead of empty

erichshiino — Tue, 05 Jul 2011 10:08:56 GMT

Hi, Jacq

I don't know if there is a limitation for those macros when you use expressions... can't you put that expression in your script and then use it as a regular field?

Regards,

Erich