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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Making a pricelist where some price is different every month

This is a beginners question I want to make an pricelist in QlikView. This is gonna be used for a sales overview report i am supposed to make.

This excample is a pricelist for Fruits. All fruits have a constant price through the year, but there is one item(FruitBasket) that have different price every month. I have one table called PriceList with fields: "Price" and "Product". When the value in the productfield is fruit basket the pricefield need to get price from another table but im not sure how to do this. I have made the FruitBasketPrice table with fields: "Month" and "Price" table but i don't know how to link them.

0 Replies