topic Re: Using Flags in Load Script in QlikView

Using Flags in Load Script

Sat, 18 Jun 2011 10:40:53 GMT

Hi guys,

I have searched the forum looking for posts relating to using flags in Load script to simplify expressions in charts. Oleg had a post, but the link to the post does not work anymore. Can someone please provide a very basic, simple and clear example of how to use these flags as I am unsure of how to do it?

Thank you

Using Flags in Load Script

kaushiknsolanki — Sat, 18 Jun 2011 10:46:54 GMT

Hi,

You can use variables in scripts which can act like a flag.

Will you please explain what you want to achieve using flags.

Thanks & Regards,

Kaushik Solanki

Using Flags in Load Script

Sat, 18 Jun 2011 11:32:56 GMT

I m trying to do something like this as an expression,

count ({<Strat1 ={'1'}, app_date = strat_date>}distinct customer_id)

but from my understanding, in set analysis you can't compare two fields together, as the app_date and the strat_date are both fields in my application. I have been advised to try and use flags in the load script to handle this, so any thoughts on this or any other way of re-writing this expression to get it to satisfy those conditions would be appreciated.

Thanks

Re: Using Flags in Load Script

nagaiank — Sat, 18 Jun 2011 14:10:49 GMT

Though I do not know the requirements of your application nor what you are trying to do, I can answer a part of your question.

When you were advised to try the use of flag, probably s(he) meant this:

(1) In the logical table having the fields app_date and strat_date, add a field (let us call it 'date_flag') which is true when the dates are equal. (You can do this by adding (app_date = strat_date) as date_flag in your load script.

(2) Use this flag in your set analysis expression instead of comparing dates (e.g. count ({<Strat1 ={'1'}, date_flag = {'true'}>}distinct customer_id)

Hope this helps.

Using Flags in Load Script

Sat, 18 Jun 2011 19:14:44 GMT

Thanks for your reply krishnamoorthy. I will try it out and let you know how it goes