topic Re: flags list box in QlikView

flags list box

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have created two flags as

Initiated as flag1

Not Initiated as flag2

Here i need to show Initiated and Not Initiated status in an list box.

Thanks..

Re: flags list box

narendiran — Thu, 11 Aug 2016 12:22:16 GMT

Hi Naresh,

Use Inline Load or mapping.

Re: flags list box

avinashelite — Thu, 11 Aug 2016 12:24:33 GMT

Create an INLINE table like

LOAD * inline

[

Status

Initiated

Not Initiated

];

then in the script you need to join this with the flags using a link table or you could set a trigger so that whenever the selection is made in the this field it will trigger a selection in the flag1 and flag2

Re: flags list box

Gysbert_Wassenaar — Thu, 11 Aug 2016 12:29:36 GMT

Create a field like this instead: If(Initiated=1, 'Ínitiated', 'Not initiated') as Status

Re: flags list box

nareshthavidishetty — Thu, 11 Aug 2016 12:49:24 GMT

Hi,

The flags were created in two different tables.

Thanks..

Re: flags list box

nareshthavidishetty — Thu, 11 Aug 2016 13:03:31 GMT

Hi Avainash,

I have created an inline but let me know how to link this to the chart.

Thanks..

Re: flags list box

avinashelite — Thu, 11 Aug 2016 13:05:05 GMT

how the Initiated & NOT Initiated values are linked with this flags ?? could you please explain us on the same

Re: flags list box

nareshthavidishetty — Thu, 11 Aug 2016 13:12:16 GMT

Hi Avinash,

Please find below.

CONTRACTS:

LOAD Store_Id as StoreID,

Store_Id as Sign_Store_ID,

[Activated Date],

'1' as flag,

'Initiated' as flag2,

[eSign Percentage]

FROM

XYZ;

Store_Info:

LOAD

Store_Id as other_Store_ID,

'eSign Not Initiated' as flag1

FROM

XYZ;

Thanks..

Re: flags list box

avinashelite — Fri, 12 Aug 2016 08:10:07 GMT

how this flag 1 and 2 are related ??

Re: flags list box

Anonymous — Fri, 12 Aug 2016 08:18:15 GMT

Hi,

Create an table with this values:

Selections:

LOAD DISTINCT flag2 as FlagSelect RESIDENT CONTRACTS;

LOAD DISTINCT flag1 as FlagSelect RESIDENT Store_Info;

Then, on Field Actions, create one action on FlagSelect field, with this actions:

On Select -> Select on field

Field: IF(GetSelectedCount(FlagSelect) = 1 and FlagSelect = 'Initiated', 'flag2',

IF(GetSelectedCount(FlagSelect) = 1 and FlagSelect <> 'Initiated', 'flag1'))

FieldValue: IF(GetSelectedCount(FlagSelect) = 1,FlagSelect)

Regards!!!