topic Re: Flag in QlikView

Flag

Mon, 15 Oct 2012 06:45:24 GMT

Can I get help that how to create morning and evening flag with two sets of qvd's. In single app when i click on morning it should filter morning daa else evening.

Both set of qvd's should be loaded by evening and should be able to analyse. How to create such flag any idea I can get?.

Re: Flag

thomas_skariah — Mon, 15 Oct 2012 07:04:19 GMT

Hi Suneel,

You can filter the time variation for morning and store it into qvd as morining.

Similar filteration can do for evening also

Regards,

Tom

Re: Flag

Mon, 15 Oct 2012 07:16:53 GMT

K i have currently same set of qvd's. I want to create with same qvd's morning and evening flag also. So how to create flag after creating two sets of qvd. I want

that flag scripting.

Re: Flag

sivarajs — Mon, 15 Oct 2012 07:29:22 GMT

You may try with this,

Tab1:

LOAD *,'Morning' as Flag;

LOAD * Inline [

Var,Val2

A,5

B,10

];

Tab2:

LOAD *,'Evening' as Flag;

LOAD * Inline [

Var,Val2

C,15

D,20

];

Re: Flag

thomas_skariah — Mon, 15 Oct 2012 08:38:17 GMT

Hi,

Not sure whether you are looking for this

sample one

Morning:

load *,

'Morning' as flag

from test.xls

where datetime> '------' and daterime< '----' ;

store Morning into 'your path'.qvd

Evening:

load *,

'Evening' as flag

from test.xls

where datetime> '------' and daterime< '----' ;

store Eveninginto 'your path'.qvd

Regards,

Tom

Re: Flag

Mon, 15 Oct 2012 11:33:39 GMT

Thanks for your help.

I have nearly 8 qvd's in two sets of qvd's. So if i add flag in morning and evening sets of qvd's and later i will do concatenation. After this I will be having flag filed

in all 8 qvd's. It will create circular reference or synthetic as alreally i have built data model. For this I have a thought but I am not sure whether that works.

My thought is like, I will comment out flag field in 7 Qvd's except 8 th.Then it filters for all data. I dont this it would filter ....For this i need QV expert's suggestion.

Re: Flag

Mon, 15 Oct 2012 13:29:14 GMT

We use concatenation always for fact or transactional table right? If so den issue resolved. Please do let me know.