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: 
shahamel
Creator
Creator

All values

Dear QV-users,

I want to see all values

Case:

I have 12 values

3,4,4,4,7,10,11,12,14,16,17,18

I want to see each value; instead of 3,4,7,10,11,12,14,16,17,18

Any help please

Gr. shahamel

1 Solution

Accepted Solutions
swuehl
MVP
MVP

You want to see each value where? In a list box, chart dimension or ...?

You may try something like

LOAD *, dual(FIELD,recno()) as AllValues INLINE [

FIELD

3

4

4

4

7

10

11

12

14

16

17

18

];

and display AllValues field in a listbox.

Hope this helps,

Stefan

View solution in original post

2 Replies
swuehl
MVP
MVP

You want to see each value where? In a list box, chart dimension or ...?

You may try something like

LOAD *, dual(FIELD,recno()) as AllValues INLINE [

FIELD

3

4

4

4

7

10

11

12

14

16

17

18

];

and display AllValues field in a listbox.

Hope this helps,

Stefan

shahamel
Creator
Creator
Author

It does the trigger . I will change it into the correct answer when i fully tested your answer. I asked my question because i wanted to make a box plot with correct values

http://community.qlik.com/thread/66112

But i thank you for your helpfull and i hope correct answer.

Gr. Sandeep