Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kicchu465
Creator
Creator

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
Anonymous
Not applicable

7 Replies
kicchu465
Creator
Creator
Author

Hi

could you please update on above thread.

Thanks

Anonymous
Not applicable

Try

Chanty4u
MVP
MVP

stalwar1‌   have look on this ?

kicchu465
Creator
Creator
Author

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
Not applicable

let me understand your problem correctly


you want a bar chart (pivoted)

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

Anonymous
Not applicable

here

kicchu465
Creator
Creator
Author

Thanks very much Baslo.

I got what I was expecting.