topic Re: Expression help in QlikView

Expression help

Tue, 16 Sep 2014 12:23:18 GMT

Hi I have expression below, i want to deduct 100 from that.

100 - expresion. The resulst should be 2 decimals with percentage.

=num(TextCount({<Month = {'$(vMonth)'}, Year = {'$(vYear)'}>}Topic) / count(count1) , '#.00 %')

ajaykumar1 — Tue, 16 Sep 2014 12:24:44 GMT

Hi ,

Try like;

=100-(num(TextCount({<Month = {'$(vMonth)'}, Year = {'$(vYear)'}>}Topic) / count(count1) , '#.00 %'))

Regards,

Ajay

Tue, 16 Sep 2014 12:26:21 GMT

Hi Ajay,

I already tried. forgot to mention - The resulst should be 2 decimals with percentage.

ajaykumar1 — Tue, 16 Sep 2014 12:30:35 GMT

Hi,

Above expression not worked?

For 2 decimals Go to your table---Right click properties---Number---select your expression in left side---Fixed to 2

and select the show in percentage check box.

Regards,

Ajay

Tue, 16 Sep 2014 12:32:06 GMT

Hi,

Unfortunately I am using Textbox.

Tue, 16 Sep 2014 12:36:04 GMT

Any one help?

ajaykumar1 — Tue, 16 Sep 2014 12:38:28 GMT

Hi,

Can you tell me how you created the TEXT Box.Am new to text box.

Thanks,

Ajay

PrashantSangle — Tue, 16 Sep 2014 12:39:04 GMT

Hi,

Then Try,

=Num(100-(num(TextCount({<Month = {'$(vMonth)'}, Year = {'$(vYear)'}>}Topic) / count(count1) , '#.00')) ,'#.00 %')

Regards

Tue, 16 Sep 2014 12:41:30 GMT

This should do the trick:

=num(100-(TextCount({<Month = {'$(vMonth)'}, Year = {'$(vYear)'}>}Topic) / count(count1) , '#.00 %'))