Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Calculated dimension in Qlik sense Gauge chart 3.1 version

Hi Guru's

I have a chart in Qlik view  ,gauge chart with Dimension.

Dimension:

=IF(NOT(Match(Product_Interest__c, 'DMPK Assay Submission', 'DMPK Portal',

'Antimicrobial Assay Submission')) AND LEFT(ConvertedOpptyName, 21) <>

'Antimicrobial Express' AND Name <> 'Rex Watkins' AND LeadSource <> 'Prospecting New Contact', 1, Null())

measure:

Avg(NetworkDays(If(IsNull(Reassignment_Date__c), Date, Reassignment_Date__c),

If(IsNull(Lead_Qualified_Date) OR ConvertedDate < Lead_Qualified_Date, ConvertedDate, Lead_Qualified_Date))-1)

i want to migrate Qlikview chart into Qlik sense chart ,but in Qlik sense there is no provision of using dimension in Gauge chart.(in my Qlik sense version)

How to achieve my requirement ,any help would be greatly appreciated.

Thanks,

Rajiv

0 Replies