Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
vickyvis
New Contributor

Data Consideration depending on requirement

Hi Team,

I have a master data file loaded into the QV. Now i have two different calculations to be done in two different tabs. One tab contains all the data and calculations related to sales and the other tab contains all the data and calculations related to profit.

But the data for the Sales and Profit is combined as single data in the master data file. Please find the attached sample data.

Now my query is when i am calculating the Sales, i need to consider only the 'Sales' data available under COA Level 6 and 'Sales to third Party' under COA Level 7.

When i am calculating Profit i need to consider only the 'Profit' data available under COA Level 5.

Please let me know  how to achieve this. 

Thanks

Vicky

Community Browser