Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Safe ticks in checkbox to QVD file

Currently I have a listbox based on the inline load:


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
MVP & Luminary
MVP & Luminary

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