topic Re: urgent help on expression in QlikView

urgent help on expression

Wed, 17 Sep 2014 10:11:36 GMT

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.

MK_QSL — Wed, 17 Sep 2014 10:13:30 GMT

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

Anonymous — Wed, 17 Sep 2014 10:16:01 GMT

Hi,

Try below script code.

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

Thanks

Wed, 17 Sep 2014 10:45:50 GMT

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 %')

Wed, 17 Sep 2014 10:46:10 GMT

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 %')

MK_QSL — Wed, 17 Sep 2014 10:49:36 GMT

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

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

PrashantSangle — Wed, 17 Sep 2014 10:51:05 GMT

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