Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
kicchu465
Contributor

Cross Table Load with Resident

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.

   

NOPQRSTU
10222113886891094299567529182402200
6317928153423385417058745510-720
4067117802107753885950151027200
1043591049207816942718901716910143390

Dimension:N to U

Measure : Sum(N) to Sum(U)

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

Thanks

Sk

1 Solution

Accepted Solutions
delroekid
Contributor

Re: Cross Table Load with Resident

here

7 Replies
kicchu465
Contributor

Re: Cross Table Load with Resident

Hi

could you please update on above thread.

Thanks

delroekid
Contributor

Re: Cross Table Load with Resident

Try

Chanty4u
Esteemed Contributor III

Re: Cross Table Load with Resident

stalwar1‌   have look on this ?

kicchu465
Contributor

Re: Cross Table Load with Resident

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

delroekid
Contributor

Re: Cross Table Load with Resident

let me understand your problem correctly


you want a bar chart (pivoted)

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

delroekid
Contributor

Re: Cross Table Load with Resident

here

kicchu465
Contributor

Re: Cross Table Load with Resident

Thanks very much Baslo.

I got what I was expecting.