Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Ivan
Best Regards
Column Product is Dimension
Next Columns are Measures
Remove Your Column and add as Measure.
Hi Ivan,
I think column is corrupt.
Create new column with same expression
Regards,
Antonio
Antonio
Thank you for your reply
However, it still doesn't work. May I know why the column will corrupt?
Could you kindly attache the qvf file for my reference?
Thanks
Ivan
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) ))
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
Thanks
Ivan
Column Product is Dimension
Next Columns are Measures
Remove Your Column and add as Measure.
Hi'
Check It.
Best.