Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to assign a range of vales to a variable

Hi Team,

Is there any way to assign a varible that takes any vaues apart from Zero.

Lets say I want varible A which takes any thing apart from Zero.

Thanks

Pavan

2 Replies
alexandros17

A variable keep only a value in a certain time but values can be managed as in the following example:

Set A = getfieldselections(myField);

...

marcarreras
Specialist
Specialist

pavan,

let's say you have a variable with some values. Then, you can set another one that takes default value in case of zero:

let VarA=...  ;

let DefaultValueForZero=...  ;

let VarB= if($(VarA)=0, $(DefaultValueForZero), $(VarA));

Marc.