Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
agrimroquette
Contributor II

change count statement to if condition

Hi All,

i can get perfect count from this statement:-

Count({<[Feasibility Planned] = {"0", "1", "2"},[Updated Phase] = {"Feasibility"}>} [NAME OF PROJECT (Code - Title)])

how can i get list of values from above statement using "IF" condition.

Thanks,

Agreim

1 Solution

Accepted Solutions
MVP
MVP

Re: change count statement to if condition

Count(

          If(Match([Feasibility Planned] , '0', '1', '2') and Match([Updated Phase],'Feasibility') ,  [NAME OF PROJECT (Code - Title)]))

3 Replies
MVP
MVP

Re: change count statement to if condition

Count(

          If(Match([Feasibility Planned] , '0', '1', '2') and Match([Updated Phase],'Feasibility') ,  [NAME OF PROJECT (Code - Title)]))

agrimroquette
Contributor II

Re: change count statement to if condition

or i have to go like this:-

if([Feasibility Planned]='0', [NAME OF PROJECT (Code - Title)]) &

if([Feasibility Planned]='1', [NAME OF PROJECT (Code - Title)]) &

if([Feasibility Planned]='2', [NAME OF PROJECT (Code - Title)]) &

if([Updated Phase]= 'Feasibility ',[NAME OF PROJECT (Code - Title)])

??

MVP
MVP

Re: change count statement to if condition

No, it would be:

if(

     ( [Feasibility Planned]='0' OR  [Feasibility Planned]='1' OR [Feasibility Planned]='2' )

     AND  [Updated Phase]= 'Feasibility' , [NAME OF PROJECT (Code - Title)]

)

Community Browser