topic Re: Help to create a flag in QlikView

Help to create a flag

bharatkishore — Tue, 12 Feb 2019 08:32:25 GMT

Hi All,

I have two fields Equipment and Revenue Type.

In revenue type i have four columns:

2.Contract_Revenue

1.Sales_Revenue

3.Labour/Driving/Freight

4.Material_Part

Now the output i needed is whatever equipments i have when i click 1.Sales_revenue only those i need to get in a separate field.

Can you please tell me how can i get it.

Thanks,

Bharat

Re: Help to create a flag

arvind_patil — Tue, 12 Feb 2019 08:47:23 GMT

Hi,

Please use = GetFieldSelections(Fieldname)

Thanks & Regards,
Arvind Patil

Re: Help to create a flag

bharatkishore — Tue, 12 Feb 2019 08:49:38 GMT

Thanks for the reply but I need to do in script...

Re: Help to create a flag

arvind_patil — Tue, 12 Feb 2019 08:53:52 GMT

Not possible in script level.

if you performing action on front end it will not calculating at back end afterwords.
Thanks & Regards,
Arvind Patil

Re: Help to create a flag

pradosh_thakur — Tue, 12 Feb 2019 08:55:52 GMT

Hi

Your requirement is not clear may be you need to describe more.

You will click on UI but need this in script? Can you please tell us more with some proper sample data.

Re: Help to create a flag

bharatkishore — Tue, 12 Feb 2019 09:16:27 GMT

I have few columns in load script and in that i have Equipment and Revenue Type as well.

Now in script i need to write a condition that where Revenue Type is 1.Sales_Revenue get those equipments as New column.

For Ex: Revenue Type / Equipments

1.Sales_Revenue 10

2.Contract_Revenue 20

Now i need to only that 10 as new column.

Hope i am clear.

Please let me know if you need anything more.

Re: Help to create a flag

arvind_patil — Tue, 12 Feb 2019 10:26:25 GMT

May be like below:
Data:
Load * Inline [
Revenue Type ,Equipments
1.Sales_Revenue , 10

2.Contract_Revenue, 20
];

Noconcatenate
Final Data:
Load Revenue Type Equipments as [New Equipment ],
' Restricted data' as flag Resident Data Where wildmatch(Revenue Type,'1.Sales_Revenue') ;
Concatenate(Final Data)
Load * Resident Data;

Thanks & Regards,
Arvind Patil

Re: Help to create a flag

bharatkishore — Tue, 12 Feb 2019 10:32:46 GMT

Sorry Arvind, if i am not clear. I have acheived it by writing below expression.

if(Revenue_Type='1.Sales_Revenue','In Sales Data','Not In Sales Data') as Sales_Flag,

Thank you so much for your time.