Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

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

1 Solution

Accepted Solutions
OmarBenSalem

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])

View solution in original post

10 Replies
OmarBenSalem

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
Master
Master
Author

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])

OmarBenSalem

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
Master
Master
Author

showing as invalid dimension

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

OmarBenSalem

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
Master
Master
Author

yes its working thanks a lot 

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

I want two colurs

OmarBenSalem

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


soniasweety
Master
Master
Author

thanks  omerben2016

OmarBenSalem

it's omarbensalem