topic Trellis pie chat with conditions in QlikView

Trellis pie chat with conditions

kushalthakral — Fri, 11 Apr 2014 17:03:06 GMT

Dear All

i need to create a trellis pie chart for the data below:

one more column is company

so i need to calculate for particular company all models in trellis based on year

Year	Model	Sales
2009	A	300
2009	B	400
2010	A	200
2010	B	100
2011	A	355
2011	B	200

i am using expression like

=sum({<[Company]={X}>}ModelCount)/sum(Total {<FinancialYear,[Vehicle Type]={X}>} ModelCount)

Regards

Kushal

Re: Trellis pie chat with conditions

its_anandrjs — Fri, 11 Apr 2014 17:35:14 GMT

You have to calculate like

=Count( {<[Company]={'X'}>} Model ) / Count(Total {<FinancialYear=,[Vehicle Type]={'X'}>} Model)

Re: Trellis pie chat with conditions

kushalthakral — Fri, 11 Apr 2014 17:40:48 GMT

Hi Anand

But ModelCount is my field name and i m counting in Script itself

can you tell me the sample expression if we gave two conditions in sum for Trellis

Re: Trellis pie chat with conditions

its_anandrjs — Fri, 11 Apr 2014 17:47:51 GMT

If ModelCount is a field then it will ok but in second script FinancialYear is a field if so then use it like FinancialYear= for bypass because you cant use it like FinancialYear

But try to check that it is working script

=sum({<[Company]={'X'}>}ModelCount) / sum(Total {<FinancialYear=,[Vehicle Type]={'X'}>} ModelCount)

Re: Trellis pie chat with conditions

kushalthakral — Fri, 11 Apr 2014 18:09:06 GMT

i have tried but it is not working

Can u plz help me in achieving that

Re: Trellis pie chat with conditions

Fri, 11 Apr 2014 18:34:03 GMT

Did u want to achieve somewhat like this.

Re: Trellis pie chat with conditions

kushalthakral — Fri, 11 Apr 2014 18:37:35 GMT

Hi all

Thanks for ur support

i have found out the solution