Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
doyleax123
Partner
Partner

Removing table associations

I have a table with quantity ordered by items, and then two separate price tables. The app needs to be designed to allow users to select one of the pricing tables, and then calculate a cost by multiplying price from the selected table * quantity from the table that they're both linked to. However the app seems to be completely blowing up the calculations and associating the two pricing tables. They're not linked together, but they're both linked to the quantity table. Is there any other way to facilitate this? Alternate states? I'm not quite sure what would be the best approach.

Labels (1)
1 Reply
chrismarlow
Specialist II
Specialist II

Hi,

I would put all the prices in 1 table (making any inconsistent fields consistent) with a 'Price Source' field that you would then use to toggle between the two.

Cheers,

Chris.