Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

bharatkishore
Contributor III

Help to create a flag

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

1 Solution

Accepted Solutions
bharatkishore
Contributor III

Re: Help to create a flag

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.

7 Replies
arvind_patil
Valued Contributor III

Re: Help to create a flag

Hi,

Please use = GetFieldSelections(Fieldname)

Thanks & Regards,
Arvind Patil
bharatkishore
Contributor III

Re: Help to create a flag

Thanks for the reply but I need to do in script...
Highlighted
arvind_patil
Valued Contributor III

Re: Help to create a flag

Not possible in script level.

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

Re: Help to create a flag

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.
Learning never stops.
bharatkishore
Contributor III

Re: Help to create a flag

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.

arvind_patil
Valued Contributor III

Re: Help to create a flag

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



bharatkishore
Contributor III

Re: Help to create a flag

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.