how to make the field constant

[Karim_Khan]

Hi Team,

    I want to know how to put the fields constant on the basis of selection and it should not impact or changes the value of other calculations.

How to achieve the same Pls  help?

Regards,
KK

[Qrishna]

fields constant?

you mean lock the field values? or field values should not change upon  selections in another field?

explain a bit more.

[#3]

If you want to lock try :

- click right on mouse in bar and select 'Detach'

If it's not what you want please specify more

[jagan]

Hi,

Your requirement is not clear, can you come up with an example and your expected output.  If you want ignore the selections in the Expression then you can use like below

Sum({<Dimension1=, Dimension2=, DimensionN=>} Sales)

The above expression ignore the selections in the Dimensions 1 to N, or you can specify

Sum({1} Sales)

This will always show the overall sales.

Regards,

Jagan.

[Karim_Khan]

=sum({$<[Fiscal Year] = {$(=only([Fiscal Year]))},[Month in Fiscal Year] = {'<=$(=only([Month in Fiscal Year]))'},CATEGORY={'IOT'},[Sales Level 2]={"$(vSel2)"}>} [Net Bookings])

I want that the value of Sales Level 2 doesn't change if I select the Sales level 1.

[jagan]

I didn't get u, can you attach sample file.

[qlikviewwizard]

Hi Karim,

Please attach the sample app with the data. SO that it would be easier to understand your requirement.

[Anonymous]

U could create a alternate state for your sales level 2 list as below. See if it applies to your need.

vSel2 = Concat({[Alternate State]}[Sales Level 2],',')

[Karim_Khan]

Hi Fernando,

   Can you pls help what is the use of Alternate State in above expression?

Regards,

KK

[#10]

Use alternate states or lock the fields from the selections