topic Re: Cross Table Load with Resident in QlikView

Cross Table Load with Resident

kicchu465 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Dimension:N to U

Measure : Sum(N) to Sum(U)

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

Thanks

kicchu465 — Fri, 18 May 2018 03:12:15 GMT

could you please update on above thread.

Thanks

Anonymous — Fri, 18 May 2018 05:45:33 GMT

Try

Chanty4u — Fri, 18 May 2018 05:56:46 GMT

stalwar1‌ have look on this ?

kicchu465 — Fri, 18 May 2018 06:20:48 GMT

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 — Fri, 18 May 2018 06:25:13 GMT

let me understand your problem correctly

you want a bar chart (pivoted)

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

Anonymous — Fri, 18 May 2018 06:35:28 GMT

here

kicchu465 — Fri, 18 May 2018 10:06:51 GMT

Thanks very much Baslo.

I got what I was expecting.