topic Re: How to make this chart in QlikView

How to make this chart

Wed, 25 Nov 2020 16:16:04 GMT

Hi guys,

A, B, C, D, F -> are coming from one field so it is dimension.

P, Q, R, S, T -> are derived fields so i am using as expression.

How to achieve E which is derived and E+F

Plz help

Thanks.

Gysbert_Wassenaar — Fri, 05 Aug 2016 11:29:26 GMT

A, B, C, D, F -> are coming from one field so it is dimension.

Create a new field from that in a new table:

NewTable:

LOAD * inline [

Field1, NewField

A, A

B, B

C, C

D, D

A, E

B, E

C, E

D, E

A, G

B, G

C, G

D, G

F, F,

F, G

];

Then use NewField as dimension in the chart instead of Field1.

Fri, 05 Aug 2016 11:50:58 GMT

Thanks.

And if some of the value i dont want to see in new field how can i achieve that ?

rajeshqvd — Fri, 05 Aug 2016 12:19:49 GMT

simply put Column(1)+Column(2)+Column(3)+Column(4) for E and Column(5)+Column(6) for E+F

rajeshqvd — Fri, 05 Aug 2016 13:32:29 GMT

use set analysis and filter what you want

Gysbert_Wassenaar — Fri, 05 Aug 2016 14:13:21 GMT

Leave them out.