topic Re: Help need in Alt function in QlikView

Help need in Alt function

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am having below scenario. I am getting Ticket_Numbers from two different tables (Historical & Current). So my pivot table needs to show the either one of the ticket number based on availability

All I need to show from either one of the fields.

History:

F1,F2

AA,T1

BB,T2

Current:

F3,F4

AA,

Expected O/P

F5,F6,Ticket

WW,EE,T1

ER,GH,T2

Note:

I was trying to show Alt(F2,F4)

Re: Help need in Alt function

sunny_talwar — Sat, 30 Apr 2016 20:48:32 GMT

How is History table and Current table connected to one another? I don't see any common fields here

Re: Help need in Alt function

trdandamudi — Sat, 30 Apr 2016 20:49:47 GMT

I don't see any relation, Am I missing something here ?

Re: Help need in Alt function

marcus_sommer — Sun, 01 May 2016 06:35:24 GMT

I think you should concatenate both tables like:

Tickets:

Load F1, F2, 'History' as Source From History;

concatenate

Load F3 as F1, F4 as F2, 'Current' as Source From Current;

and then you would probably don't need a logic like your alt() approach but of course with the Source field you could differ from where your values come from, for example:

count({< Source = {'Current'}>} F1)

- Marcus