Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Not applicable

'Or' Conditions in NPrinting Reports

Hi,

I need to build a  report in NPrinting which should be generated when one of 5 particular conditions is fulfilled.

As I understand, there is no such a thing in QV- 'or' between conditions?

Only 'and'?

So I will need to create 20 different reports as also any combination between the conditions should generate that report?

Seems to be irrational.

Can you advise, please?

Thanks,

Inna

1 Solution

Accepted Solutions
avinashelite
Not applicable

Re: 'Or' Conditions in NPrinting Reports

As per I know we don't have direct way to achieve this ...try like this

compare all the variable values and create a new variable i.e.

vResult //Create new variable in Qlikview

if(v1='1' OR v2='2' OR v3='3' OR v4='4' OR v5='5',1,0)

//Definition of the variable in Qlikview


Now compare only variable in NPrinting


Hope this helps you



4 Replies
avinashelite
Not applicable

Re: 'Or' Conditions in NPrinting Reports

You could use a IF condition rite??

if(condition1='1' OR condition2='2' OR condition3='3' OR condition4='4' OR condition5='5',true,false)

Not applicable

Re: 'Or' Conditions in NPrinting Reports

Hi Avinash.

I need to make 'Or' between conditions in NPrinting:

avinashelite
Not applicable

Re: 'Or' Conditions in NPrinting Reports

As per I know we don't have direct way to achieve this ...try like this

compare all the variable values and create a new variable i.e.

vResult //Create new variable in Qlikview

if(v1='1' OR v2='2' OR v3='3' OR v4='4' OR v5='5',1,0)

//Definition of the variable in Qlikview


Now compare only variable in NPrinting


Hope this helps you



Not applicable

Re: 'Or' Conditions in NPrinting Reports

Hi Avinash,

it helped.

Community Browser