Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to do calculation?

Hi All,

I am new to Qlikview.

Now, i am trying to create some sample reports in qlikview for my project. That report, contains data from 4 tables. I am joining those tables inside qlikview using Load commands like this

I want to calculate the percentage of 2 fields from different tables ( different load)

How to do that?

4 Replies
srinivasa1
Creator II
Creator II

Qlikview will make auto join based on common clos in both the tabel.in expersion you just write % logic on filed

Not applicable
Author

Hi Shriram can you please give me a sample code ?

I want to use "SEG_CY_VOLUME" from last table (DYF_SEGMENT_SALES) and  "CY_VOLUME" from 4th table (DYF_VEHICLE_SALES)

I tried adding the % logic in the first load but got an error like the field is not available.

srinivasa1
Creator II
Creator II

You need use concatenate or resident tabel concept. so you make single table and apply % logic or you can upload you sample app.

Not applicable
Author

Surenther,

Upload an sample document.