Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

urgent help on expression

Hi,

I have expression.

= count( {$<CtrlOnYear=,CtrlOnDay=,CtrlOnMonth=, CtrlOnDate= {"<=$(=date(vMaxDate))"}>} Count)

I want to add one more condition.

- ONly Count where Success = 1.

How to do that.

1 Solution

Accepted Solutions
MVP
MVP

Re: urgent help on expression

= count( {$<CtrlOnYear=,CtrlOnDay=,CtrlOnMonth=, CtrlOnDate= {"<=$(=date(vMaxDate))"}>} If(Success = 1, Count))

View solution in original post

6 Replies
MVP
MVP

Re: urgent help on expression

= count( {$<CtrlOnYear=,CtrlOnDay=,CtrlOnMonth=, CtrlOnDate= {"<=$(=date(vMaxDate))"}>} If(Success = 1, Count))

View solution in original post

Highlighted
dhirajkumar
Contributor

Re: urgent help on expression

Hi,

Try below script code.

= count( {$<CtrlOnYear=,CtrlOnDay=,CtrlOnMonth=, CtrlOnDate= {"<=$(=date(vMaxDate))"},Success = {1}>} Count)


Thanks

Not applicable

Re: urgent help on expression

Hi Manish,

I have to do 100 - expression and %.

I am trying as below but giving error:

= Num(100-(= count( {$<CtrlOnYear=,CtrlOnDay=,CtrlOnMonth=, CtrlOnDate= {"<=$(=date(vMaxDate))"}>} If(Success = -1, Count))/

count( {$<CtrlOnYear=,CtrlOnDay=,CtrlOnMonth=, CtrlOnDate= {"<=$(=date(vMaxDate))"}>}  Count)),, '#.00 %')

Not applicable

Re: urgent help on expression

Hi Dhiraj,

I have to do 100 - expression and %.

I am trying as below but giving error:

= Num(100-(= count( {$<CtrlOnYear=,CtrlOnDay=,CtrlOnMonth=, CtrlOnDate= {"<=$(=date(vMaxDate))"}>} If(Success = -1, Count))/

count( {$<CtrlOnYear=,CtrlOnDay=,CtrlOnMonth=, CtrlOnDate= {"<=$(=date(vMaxDate))"}>}  Count)),, '#.00 %')

MVP
MVP

Re: urgent help on expression

NUM(100-(count( {$<CtrlOnYear=,CtrlOnDay=,CtrlOnMonth=, CtrlOnDate= {"<=$(=date(vMaxDate))"}>} If(Success = 1, Count))/

count( {$<CtrlOnYear=,CtrlOnDay=,CtrlOnMonth=, CtrlOnDate= {"<=$(=date(vMaxDate))"}>} Count)),'#,##0.00%')

Re: urgent help on expression

Hi,

Why is there two ,, at end

= Num(100-(= count( {$<CtrlOnYear=,CtrlOnDay=,CtrlOnMonth=, CtrlOnDate= {"<=$(=date(vMaxDate))"}>} If(Success = -1, Count))/

count( {$<CtrlOnYear=,CtrlOnDay=,CtrlOnMonth=, CtrlOnDate= {"<=$(=date(vMaxDate))"}>}  Count)) ,,

'#.00 %')

try

with single , and above solutions

Regards

Great dreamer's dreams never fulfilled, they are always transcended.