Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
soniasweety
Valued Contributor III

double values

Hi all,

kaushik.solanki

youssefbelloumomerben2016

is there any way to show both values and %  at a time on pie chart Qliskense?

anyone has some sample please share

Tags (1)
1 Solution

Accepted Solutions
Partner
Partner

Re: double values

the

sum(YourMeasure) = count({<JDate={">=$(=vStartDate)<=$(=vEndDate)"},[JStatus]={'Joined'}>}[ID])


maybe it's a syntax thing: let's try again:

dimension:

=[In/Ex]&' : '& aggr(num(count({<JDate={">=$(=vStartDate)<=$(=vEndDate)"},[JStatus]={'Joined'}>}[ID])

/count( total {<[In/Ex]=,JDate={">=$(=vStartDate)<=$(=vEndDate)"},[JStatus]={'Joined'}>}[ID]),'#,##0.00%'),[In/Ex])


measure:

count({<JDate={">=$(=vStartDate)<=$(=vEndDate)"},[JStatus]={'Joined'}>}[ID])

10 Replies
Partner
Partner

Re: double values

sure:

in u pie chart;

as dimension:

=YourDim&' : '& aggr(num(sum(YourMeasure)/sum(total{<YourDim>} YourMeasure),'#,##0.00%'),YourDim)

as a measure:

sum(YourMeasure)



Under aspect > presentation, show the values:

Capture.PNG

result (per aalogy): Capture.PNG

soniasweety
Valued Contributor III

Re: double values

thanks.

but in my case its not working  below am using  what is the issue here?

Dim: [In/Ex]

Meausre:count({<JDate={">=$(=vStartDate)<=$(=vEndDate)"},[JStatus]={'Joined'}>}[ID])

=[In/Ex]' : '& aggr(num(sum(count({<JDate={">=$(=vStartDate)<=$(=vEndDate)"},[JStatus]={'Joined'}>}[ID]))

/sum(total{<[In/Ex]>}

count({<JDate={">=$(=vStartDate)<=$(=vEndDate)"},

[JStatus]={'Join'}>}[ID])),'#,##0.00%'),[In/Ex])

Partner
Partner

Re: double values

Your dim would be :

=[In/Ex]' : '&

aggr(num( (count({<JDate={">=$(=vStartDate)<=$(=vEndDate)"},[JStatus]={'Joined'}>}[ID])

/

count(total {<[In/Ex]=, JDate={">=$(=vStartDate)<=$(=vEndDate)"},[JStatus]={'Joined'}>}[ID])),'#,##0.00%'),[In/Ex])

soniasweety
Valued Contributor III

Re: double values

showing as invalid dimension

and what could be my measure?  can I add sum(my meausre) ?

Partner
Partner

Re: double values

the

sum(YourMeasure) = count({<JDate={">=$(=vStartDate)<=$(=vEndDate)"},[JStatus]={'Joined'}>}[ID])


maybe it's a syntax thing: let's try again:

dimension:

=[In/Ex]&' : '& aggr(num(count({<JDate={">=$(=vStartDate)<=$(=vEndDate)"},[JStatus]={'Joined'}>}[ID])

/count( total {<[In/Ex]=,JDate={">=$(=vStartDate)<=$(=vEndDate)"},[JStatus]={'Joined'}>}[ID]),'#,##0.00%'),[In/Ex])


measure:

count({<JDate={">=$(=vStartDate)<=$(=vEndDate)"},[JStatus]={'Joined'}>}[ID])

soniasweety
Valued Contributor III

Re: double values

yes its working thanks a lot 

but colour it  is showing grey only one colour . total pie. ?

I want two colurs

Partner
Partner

Re: double values

under color, color by dimension and choose ur original dimension (not the modified one) but [In/Ex].


soniasweety
Valued Contributor III

Re: double values

thanks  omerben2016

Partner
Partner

Re: double values

it's omarbensalem