Cross Table Load with Resident

[kicchu465]

Hi Experts,

I am new to qlik and I have a requirement as below.

1.To Display the total Count of Cust by IND using a bar Chart which is a straight forward and I have done that.

Dimension: IND

Measure:Count(Cust)

2. To show the total value under below coloumns using a bar chart Chart.

N	O	P	Q	R	S	T	U
102221	1388689	1094299	5675	291824	0	220	0
63179	281534	233854	17058	74551	0	-72	0
4067	117802	107753	8859	50151	0	2720	0
104359	1049207	816942	71890	171691	0	14339	0

Dimension:N to U

Measure : Sum(N) to Sum(U)

Could you please let me know how can I achieve this scenario.

Thanks

Sk

[kicchu465]

Hi

could you please update on above thread.

Thanks

[Anonymous]

Try

[Chanty4u]

stalwar1‌   have look on this ?

[kicchu465]

Hi  Basalo,

Thanks for your reply.

When I execute the second senario then it is working fine but how can show scenario 1 and 2.

When I am executing them as two seperate table there are synthetics been created and I need to elimate those keys.

Thanks

[Anonymous]

let me understand your problem correctly

you want a bar chart (pivoted)

and you want to display the details also? (unpivot?)

[Anonymous · Accepted solution]

here

[kicchu465]

Thanks very much Baslo.

I got what I was expecting.