Discussion Board for collaboration related to QlikView App Development.
How can i write Where Exists condition in qlikview by using "AND" can any one give with Example ?
where exists(a) and (b='1')
load all data where datarow with a laready loaded and b contains value 1
Here Data like this
Here i want matching months dynamically
you can try like this:
LOAD DATE FROM [mySource1];
Load DATE1 FROM [mySource2] WERE EXISTS(DATE,DATE1 );
Hope this helps.
T1: load * inline [ DATE Jan Feb Mar ]; T2: load * Inline [ DATE1 Jan Feb Mar Apr Jul ]; Test: NoConcatenate load DATE1 Resident T2 where Exists(DATE,DATE1)
gets you this result (is it what you want?)
I have Date field i changed to month i done how you guys said but i am not getting
cyn aou post sampe qvw?
are the monthfield in two tables are same Format?
While reloading time also Where condition table lines showing fetching zero lines
if i remove the where condition lines fetching started
Do you have month fields as the same thing? I mean may be one month is dual field created using Month() function and the other one is text created inline may be?