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: 
qlikmark1990
Contributor III
Contributor III

Convert QLikView pie-chart with two expressions to QLikSense pie chart

First I made a pie-chart in QLikView that has two expressions but no dimension. The two expression in the chart are: =SUM(FactNat) and =SUM(FactInt).

I tried to create the same chart in QLikSense but my problem is that QLikSense obliged me to create a dimension that the current pie chart doesn't contain.

pie chart.png

My pie-chart in QLikView

2018-09-10_1453.png2018-09-10_1454.png

When I added the two expressions to the pie-chart, I don't get a visualization. What do I need to put as dimension to the pie-chart?

I tried to add FactInt as dimension that results to:

2018-09-10_1458.png

And FactNat results to:

2018-09-10_1458_001.png

How do I get the pie-chart shown in QLikView?

1 Solution

Accepted Solutions
Lisa_P
Employee
Employee

Try this:

As a calculated dimension:

=ValueList('FactNat','FactInt')

As your measure:

if(ValueList('FactNat','FactInt')='FactNat',sum(FactNat),

if(ValueList('FactNat','FactInt')='FactInt',sum(FactInt)))


You will need to do some conditional colouring and labelling

View solution in original post

3 Replies
Lisa_P
Employee
Employee

Try this:

As a calculated dimension:

=ValueList('FactNat','FactInt')

As your measure:

if(ValueList('FactNat','FactInt')='FactNat',sum(FactNat),

if(ValueList('FactNat','FactInt')='FactInt',sum(FactInt)))


You will need to do some conditional colouring and labelling

qlikmark1990
Contributor III
Contributor III
Author

This is exactly what I needed, thanks.

Dan36
Contributor II
Contributor II

Nice one - exactly what I needed