topic Re: Dual function issue in QlikView

Dual function issue

buzzy996 — Wed, 16 Nov 2016 16:23:24 GMT

hi guys,

i'm trying use dual to display values on single bar like this "exp: 20 (30%)"

If i use this Count({$<Month=>}IP_No__c)--i'm getting 20

If i use this Num(Count({$<Month=>}IP_No__c)/Count(Total{$<Month=>}IP_No__c),'0.00%')*100 --- getting output as 30%

but i'm getting issue with the below expression,nay help?

dual(Count({$<Month=>}IP_No__c) & chr(10) & Num(Count({$<Month=>}IP_No__c)/Count(Total{$<Month=>}IP_No__c),'0.00%')*100,Count({$<Month=>}IP_No__c))

thanks in advance.

sunny_talwar — Wed, 16 Nov 2016 16:38:47 GMT

What is the issue that you are running into? Have you checked 'Expression Default' on the Numbers tab?

buzzy996 — Wed, 16 Nov 2016 16:42:36 GMT

yes ,sunny,

the above dual() is only giving value and it's not producing % value along with number (like in the above exp), no error.

any help?

sunny_talwar — Wed, 16 Nov 2016 16:45:23 GMT

Did you try to check 'Expression Default' on the Number tab of chart properties?

buzzy996 — Wed, 16 Nov 2016 16:46:28 GMT

Yes,

sunny_talwar — Wed, 16 Nov 2016 16:47:27 GMT

Would you be able to share a sample where this isn't working?

buzzy996 — Wed, 16 Nov 2016 16:50:44 GMT

Hey,found small thing (K) was placed on Thousand symbol that actually caused issue.

sunny_talwar — Wed, 16 Nov 2016 16:51:41 GMT

Super