Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
R_Mendoza
Contributor III
Contributor III

Pie Chart (SLOW)

Hello everyone,

How can I do that the Pie Chart does not load until the filters are completed...?

thanx.

Renzo

4 Replies
dplr-rn
Partner
Partner

unfortunatly no easy answer to the question.

By slow. how long does the load take?

What is the expression used in the pie chart?

You may need to check the whole app for performance issues as well. Use Robs document analyzer as well.

R_Mendoza
Contributor III
Contributor III
Author

Hallo @dplr-rn 

Dimension:

=If($(vChartselect) = 'Produktlinie', $(vSprachfeld_PlanPL),
If($(vChartselect) = 'Land', $(vSprachfeld_LandKDNR),
If($(vChartselect) = 'HVT', [Hauptvertretername],
If($(vChartselect) = 'Kunde', [Name Hausgruppe 1],
If($(vChartselect) = 'Produktgruppe', $(vSprachfeld_PlanPGR),
If($(vChartselect) = 'ABCAnalyse', [Kz. ABC Kunde],
If($(vChartselect) = 'Retoure', $(vSprachfeld_RETG),
If($(vChartselect) = 'Reklamation', $(vSprachfeld_RKLA)))))))))

Kennzahlen:

=-$(eGSLJ_Euro) (SUM)

dplr-rn
Partner
Partner

hard to diagnose as most of it is in variables. But i think you are have your answer right there. 

If clauses are much slower than set analysis. i dont know if your logic can be convereted. but a lot it could be theoritically be done in set analysis . alternatively create flags while loading data and use  that in set analysis too

 

Kushal_Chawda

try to convert it into pick(match expression

=Pick(match($(vChartselect) , 'Produktlinie','Land','HVT','Kunde','Produktgruppe','ABCAnalyse','Retoure','Reklamation'),
$(vSprachfeld_PlanPL),
$(vSprachfeld_LandKDNR),
[Hauptvertretername],
[Name Hausgruppe 1],
$(vSprachfeld_PlanPGR),
[Kz. ABC Kunde],
$(vSprachfeld_RETG),
$(vSprachfeld_RKLA))