Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to create a chart by considering three dimensions

Hi,

How to create  chart by considering three dimensions. This is my requirement:

Hi,

I need to create a Bar chart by Team member and error type. showing week1, week2, week3, week4 and so on on X axis and percentage of failures on Y axis. But this all should by considering Team member and error type.

For more clarification I am adding the expression

 

Sum


({<Result={'Fail'}>} distinct Reference)/Sum(Distinct(Reference))

And I need to use the calculated dimensions as

 

=

IF(FiscalWeekSerial>=$(curFiscalWeekSeq)-4,

FiscalWeek)

and how can I add columns Team Member and Error types? Could anyone help me

Thanks.

3 Replies
Clever_Anjos
Employee
Employee

Can you post a qvw with a sample of your data?

Not applicable
Author

Hi,

Please have a look on the attached and help me.

Clever_Anjos
Employee
Employee

Well...

Your qvw seems empty to me