Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
amit_shetty78
Creator II
Creator II

Help needed with data presentation

Hi All,

I need some assistance on how to get the result in the way shown below.

I have an application which loads data from 2 different databases and I am trying to put together a deck to show the correlation between them. The 2 datasets are linked via column [Item Name].

For E.g.: Dataset 1:

RecordNumber

[Item Name]

RecordDate

1122

Item1

4/1/2010

1344

Item2

4/12/2010

4532

Item3

4/13/2010

Dataset 2:

SrNo

[Item Name]

[Date Of Entry]

4567

Item1

3/31/2010

4568

Item1

3/31/2010

3456

Item1

3/20/2010

2233

Item2

4/11/2010

I want a pivot that will tell me if there was a record for an Item on a particular RecordDate then also show me the corresponding SrNo/s if any for the same Item say in the Last 24 hours based on [Date of Entry].

Result I am looking to have:

Item Name

Record Number

Record Date

Sr No

Date of entry

Item1

1122

4/1/2010

4567

3/31/2010

4568

3/31/2010

Item2

1344

4/12/2010

2233

4/13/2010

Item3

4532

4/13/2010

I think I can achieve this with 2 separate tables. When I select a RecordNumber in table 1 then based on the corresponding RecordDate I can show the SrNo/s in the last 24 hours in table 2 but I am looking to show it in just one table as shown above.

Appreciate any kind of help on this.

Thanks.

1 Solution

Accepted Solutions
pover
Luminary Alumni
Luminary Alumni

Is there a reason SrNo. 3456 doesn't exist in the resulting pivot table?

Create one pivot table with Item Name, Record Number, Record Date and Sr No as dimensions and only([Date of entry]) as the expression. That should give you the result you are looking for.

Regards.

View solution in original post

5 Replies
pover
Luminary Alumni
Luminary Alumni

Is there a reason SrNo. 3456 doesn't exist in the resulting pivot table?

Create one pivot table with Item Name, Record Number, Record Date and Sr No as dimensions and only([Date of entry]) as the expression. That should give you the result you are looking for.

Regards.

View solution in original post

Not applicable

Hi Amit,

Pls find the attached application which will help you.

Regards

Rajesh

Not applicable

Hi Rajesh,

Cant find a attachment.

- Sridhar

Not applicable

Sorry missed the attachment

amit_shetty78
Creator II
Creator II
Author

Rajesh and Karl, Thanks for the help.I'll try it out and let you guys know.

Best Rgds.