topic Re: Issue in Mandatory Selection in List Box in QlikView

Issue in Mandatory Selection in List Box

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

Hi All,

I have one list box. Having expression like below:

= '(' & Sales_Fact_ProductGroupMajor & ')' & ' - ' & ProductGroupMajorDescription

I want to make this as Mandatory. But, Always One Selected Value is disable.

Is there any way to implement this in UI level?

Please help.

Thanks,

Sarif

Re: Issue in Mandatory Selection in List Box

ElizaF — Mon, 10 Apr 2017 13:00:39 GMT

Select one value and after go to proprieties of List Box and check " Always One Selected Value".

Re: Issue in Mandatory Selection in List Box

mhmmd_srf — Mon, 10 Apr 2017 13:01:49 GMT

Eliza Sir,

I have tried in that way only....not working. That option is disable.

Please suggest.

Thanks,

Sarif

Re: Issue in Mandatory Selection in List Box

Miguel_Angel_Baeyens — Mon, 10 Apr 2017 13:05:05 GMT

You will need to create that value as a separate field in the script. Always one value selected only works with fields, not expressions.

Re: Issue in Mandatory Selection in List Box

Anil_Babu_Samineni — Mon, 10 Apr 2017 13:06:57 GMT

Here, The condition works only fields not the expressions as i know

Try like below, And then use Sample as Listbox and check

LOAD *, '(' & Sales_Fact_ProductGroupMajor & ')' & ' - ' & ProductGroupMajorDescription as Sample Inline [

Sales_Fact_ProductGroupMajor , ProductGroupMajorDescription

Sample, 1

Sample, 2

Sample, 3

Sample,4

];

Re: Issue in Mandatory Selection in List Box

ElizaF — Mon, 10 Apr 2017 13:07:30 GMT

Very curious. Close the file, open again and check.

Can you upload the QVW file?

Re: Issue in Mandatory Selection in List Box

avinashelite — Mon, 10 Apr 2017 13:15:24 GMT

It doesn't work with the Expression Dimension create that dimension in the script and use the same in front end you will be able to get that functionality

Re: Issue in Mandatory Selection in List Box

ElizaF — Mon, 10 Apr 2017 13:16:11 GMT

The script is:

LOAD

'(' & Sales_Fact_ProductGroupMajor & ')' & ' - ' & ProductGroupMajorDescription as Sample ;

LOAD * INLINE [

Sales_Fact_ProductGroupMajor , ProductGroupMajorDescription

Sample, 1

Sample, 2

Sample, 3

Sample,4

];

Pls check the file attached

Re: Issue in Mandatory Selection in List Box

mhmmd_srf — Mon, 10 Apr 2017 13:18:41 GMT

Okk...I am doing that only..

but just wanted to check whether is there any option in Front Level.

Thanks,

Sarif

Re: Issue in Mandatory Selection in List Box

tunoi — Mon, 10 Apr 2017 13:26:20 GMT

yes, there is other alternative: Here