Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ivanyang25
Contributor III
Contributor III

My ValueList can't show anything

Dear QS Expert

I am new to Qlik Sense and I have a very simple question

I create a simple ValueList as below it just can't show anything in it.

May I know why? Thank you for your advise in advance

2.PNG

3.PNG

1.PNG

Ivan

Best Regards

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

Column Product is Dimension

Next Columns are Measures

Remove Your Column and add as Measure.

View solution in original post

6 Replies
antoniotiman
Master III
Master III

Hi Ivan,

I think column is corrupt.

Create new column with same expression

Regards,

Antonio

ivanyang25
Contributor III
Contributor III
Author

Antonio

Thank you for your reply

However, it still doesn't work. May I know why the column will corrupt?

捕获.PNG

Could you kindly attache the qvf file for my reference?

Thanks

Ivan

balabhaskarqlik

May be try this:

= if(ValueList('A','B')='A',2,

    if(ValueList('A','B')='B',4,5))

or

=if( ValueList('A','B') = 'A', sum(FIELD),

if( ValueList('A','B') = 'B', count(FIELD) ))

ivanyang25
Contributor III
Contributor III
Author

Bala

I can successfully add the first column. But I fail each time when I add the 2nd column which makes me so despearte No matter which way I put expression in it

1.PNG

Thanks

Ivan

antoniotiman
Master III
Master III

Column Product is Dimension

Next Columns are Measures

Remove Your Column and add as Measure.

idogridish2
Creator II
Creator II

Hi'

Check It.

Best.