Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
bharath8
Contributor II
Contributor II

sales with corresponding p_id

Hi Experts,

I have below 2 tables tables and the fields common between both tables are-

Product, System, Location, BusinessArea. The row in yellow background is the only row common between both tables.

I will concatenate both tables.

Sales:

LOAD *,
'Sales'   
as DataSet
INLINE

[
Prouct, System, Location, BusinessArea, Sales,Date
AA, SAP, DE, Manufacturing, 67, 01/01/2017
AA, Oracle, US, IT, 80,05/01/2017
BB, SAP, UK, Accounting, 578, 08/01/2017
CC, IBM, IN, IT, 79, 13/01/2017
DD, MS, US, IT, 969, 18/01/2017
DD, IBM, US, Research, 89, 11/01/2017
]
;

Concatenate

Problems:
LOAD
*,
'Problems'     
as DataSet
INLINE
[
P_ID, Prouct, System, Location, BusinessArea
200, AA, PeopleSoft, US, Manufacturing

300, BB, SAP, UK, IT
400, CC, IBM, IN, IT
500, ZZ, Microsoft, FR, HR
]
;

My main requirement is to show Sales data in a straight table and its corresponding P_ID(may be in expression).


This above case i assume only P_ID- 400 will be shown in straight table as it is only row common between both tables.

However i want to display other P_ID's that are less common as well if a selection is made. What i mean is, if a user select Product- AA, then show P_ID - 200 along the below rows and similarly if System- SAP is selected by user, show P_ID- 300.

AA, SAP, DE, Manufacturing,

AA, Oracle, US, IT

I am not sure if straight table a good option for my requirement, but if there is better option, please guide me.

Thanks!

1 Reply
jmvilaplanap
Specialist
Specialist

Hi

Straight table is enough to show the info that you want, Why do you want to do it harder?

Also, depends of the rest of the dashboard design, maybe if you only wants to show a number, with a KPI (text label) is enough.

Regards