Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikmark1990
Contributor III
Contributor III

Safe ticks in checkbox to QVD file

Currently I have a listbox based on the inline load:

Vinkjes:

LOAD * Inline

[RijNummer, Vinkje

1, -

2, -

3, -

4, -

5, -

6, -

7, -

8, -

9, -

10, -

11, -

12, -

];

The style is windows checkboxes and what I want to do is safe the ticks to an external QVD file. First I want to make some selections and after pressing a button, safe unchecked numbers as 0 and checked numbers as 1.

How can I perform this and where to find more about writing listbox selections to a QVD file?

1 Reply
marcus_sommer

AFAIK a listbox couldn't be exported as qvd but you could use a straight-table for it with the field as dimension and an expression like the following for the selected values:

-(getselectedcount(RijNummer) > 0 and count(RijNummer) > 0)

whereby you don't need mandatory to use the straight-table for selecting the values. It could be done within your listbox but exporting the table.

Please notice that I wrote exporting and not writing - it meant you need to use macros for it and you couldn't do it within the script else only within the GUI.

- Marcus