topic Re: How can 'inherited' be used for an alternate state in a variable? in QlikView

How can 'inherited' be used for an alternate state in a variable?

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

In Thread How to use a parameter in a variable to use an alternate state in set analysis I ask a question about using alternate states in variables. This question is answered and it is working for named alternate states:

The following syntax ist working:

set fTotalDuration=(sum({$1} Duration)

In the diagrams you can use the formular like =$(fTotalDuration('Machine1')).

'Machine1' is the defined alternate state.

But now I face the problem that I cannot use this formula with inherited alternate states.

That means instead of using the named alternate state 'Machine1'

I want to use the alternate state <inherited>.

So far I could not find any possibility to use <inherited> as parameter. I tried the following combinations:

Variable without parameter: =$(fTotalDuration)
Variable with empty parameter: =$(fTotalDuration(''))
Variable with parameter '<inherited>': =$(fTotalDuration('<inherited>'))
Variable with parameter <inherited>: =$(fTotalDuration(<inherited>'))
Variable with parameter '$': =$(fTotalDuration('$'))
Variable with parameter $: =$(fTotalDuration($))

So the final question remains: How can 'inherited' be used for an alternate state in a variable?

Regards

Dirk

Re: How can 'inherited' be used for an alternate state in a variable?

sunny_talwar — Mon, 08 May 2017 14:40:56 GMT

How about this

=$(fTotalDuration(Chr(36)))

Re: How can 'inherited' be used for an alternate state in a variable?

Mon, 08 May 2017 14:51:09 GMT

Dear Sunny,

thanks for you answer, but this doesn't work.

Regards

Dirk

Re: How can 'inherited' be used for an alternate state in a variable?

sunny_talwar — Mon, 08 May 2017 14:55:59 GMT

Tried this and it worked for me

=$(fTotalDuration('$'))

and also this

=$(fTotalDuration($(=Chr(36))))

Re: How can 'inherited' be used for an alternate state in a variable?

swuehl — Mon, 08 May 2017 15:01:26 GMT

AFAIK, the dollar sign denotes the default state, not inherited state.

Inherited state would be a void set identifier, i.e.

// default set

Sum( {$<Field = {'A'}>} Value)

vs.

// inherited set

Sum( {<Field = {'A'}>} Value)

Re: How can 'inherited' be used for an alternate state in a variable?

sunny_talwar — Mon, 08 May 2017 15:04:54 GMT

But seems to be working with selection in inherited state.... for what I have seen, I have never seen difference between Inherited state and default state. There may be some difference, but don't think it is $

Selection in Inherited and Default state list box go hands in hand....

Re: How can 'inherited' be used for an alternate state in a variable?

swuehl — Mon, 08 May 2017 15:11:12 GMT

Seems like you inherited from default state...

Try using an alternate state in your sheet properties, then the text object will inherit from that.

Re: How can 'inherited' be used for an alternate state in a variable?

Mon, 08 May 2017 15:13:00 GMT

Dear Sunny,

both do not work, see attached file.

I forgot to mentioned, that sheet belongs to an alternate state 'Mac !hine 1'.

If you change this, then inherited won't work.

Regards

Dirk

Re: How can 'inherited' be used for an alternate state in a variable?

swuehl — Mon, 08 May 2017 15:13:04 GMT

Seems to work with

=$(fTotalDuration(<Field>))

// used Field as a dummy field to create a valid syntax, would be better to create another variable proper syntax to avoid this

Re: How can 'inherited' be used for an alternate state in a variable?

sunny_talwar — Mon, 08 May 2017 15:13:40 GMT

Not sure I understand, would you be able to modify my script to show how inherited state and default state differ? I always thought they are the same thing, but might have always been mistaken

Re: How can 'inherited' be used for an alternate state in a variable?

sunny_talwar — Mon, 08 May 2017 15:17:26 GMT

I guess I see what Stefan was trying to point out... So the inherited state is inheriting the state from the sheet properties. So inherited state here is also Machine 1.... why not use Default state in that case?

Re: How can 'inherited' be used for an alternate state in a variable?

antoniotiman — Mon, 08 May 2017 15:17:45 GMT

Hi Dirk,

I prefer to set variable

Sum($1 Duration)

and Expression

Sum(({'State'}) Duration)

Sum(( ) Duration

or Sum(({$}) Duration)

Regards,

Antonio

Re: How can 'inherited' be used for an alternate state in a variable?

swuehl — Mon, 08 May 2017 15:18:56 GMT

There is a hierarchy, document level -> sheet level -> chart object level where you can set the state (well, not sure about the document state, I think it's always default state). So if you set a different alternate state on sheet level, chart objects may inherit the state (or you can explicitely define the state in chart properties).

Re: How can 'inherited' be used for an alternate state in a variable?

sunny_talwar — Mon, 08 May 2017 15:19:53 GMT

Make sense now.... and clarify the difference between Inherited and Default state now....

Re: How can 'inherited' be used for an alternate state in a variable?

swuehl — Mon, 08 May 2017 15:23:46 GMT

Re: How can 'inherited' be used for an alternate state in a variable?

Mon, 08 May 2017 15:40:59 GMT

Hallo Stefan,

according to the referenced article $ indicates the default state and '' (nothing) means inherited:

Additionally, any expression in any object can either inherit the state of the object or be controlled via set analysis. And this is the key point: sum({ $ } Sales) and sum(Sales) now have potentially different meanings.

By hard-coding the $ in the set, we are explicitly choosing the good old-fashioned default state – all user selections. This ignores the alternate states. In fact, even if the object is assigned to an alternate state, by placing the $ in the set expression we are ignoring that alternate.

Contrast this to omitting the dollar-sign: sum(Sales) In this case we are accepting whatever state the object is in. That could be the default set $ … or it could be an alternate state, if indeed the object is assigned to an alternate state.

In that case I should omit the $-sign.

I tried this before:

Variable without parameter: =$(fTotalDuration)

Variable with empty parameter: =$(fTotalDuration(''))

But both options give me the result of 0 instead of the correct result.

I think the main question is how do the variables handle the parameter $1 and is there a parameter for 'nothing'?

set fTotalDuration=(sum({$1} Duration)

Re: How can 'inherited' be used for an alternate state in a variable?

swuehl — Mon, 08 May 2017 15:52:09 GMT

Sum( {} Duration)

does not seem to be valid syntax. So either create a resulting expression

Sum( Duration)

to get the inherited state applied, or as I suggested above

Sum( {<DummyField>} Duration)

(Sum({<>} Duration) does not seem to be correct too..)

It's up to you how you define your variables and variable calls to end up with a valid syntax.

Re: How can 'inherited' be used for an alternate state in a variable?

Mon, 08 May 2017 16:16:06 GMT

Dear Stefan,

according to you explanation this will work then:

Instead of

set fTotalDuration= sum({$1} Duration)

I should use:

set fTotalDuration= if(len($1)>0, sum({$1} Duration), sum(Duration))

So the correct syntax with this formula is then:

=$(fTotalDuration('Machine1'), when using alternate state Machine1

and

= $(fTotalDuration(''), when using the inherited state.

You are absolutely right, I have to ensure the right syntax in the variables. For me this was not an obvious solution.

Thanks for your help.

Dirk

Re: How can 'inherited' be used for an alternate state in a variable?

Mon, 08 May 2017 16:30:58 GMT

So the correct syntax with this formula is then:

=$(fTotalDuration('Machine1'), when using alternate state Machine1

and

= $(fTotalDuration(''), when using the inherited state.

Re: How can 'inherited' be used for an alternate state in a variable?

dwhanand — Tue, 09 May 2017 07:13:46 GMT

Hi Derk

I have a dashboard with three sheets, the user asked selection of same dimension in one sheet should not affect other two sheets.

So i created three alternate state name from document properties and applied for each of the sheets.
Now i have a date range text box (action->select in field-> for a date dimension field) with logic as

= '>=$(=date($(vStartDateNxtAD))) <=$(=date($(vEndDateNxtAD)))' Note: i used two calendar objects and stored the value in variables

This logic worked before applying the alternate state. But after applying it stopped working i.e the charts and other associated object values in that particular sheet is not changing

The dashboard is in prod.

I tried using the variable as per the thread link

All the objects of my third dashboard sheet been changed to alternate state 'AccountDetail'

and changed the text box search logic as

= '>=$(=date($(vStartDateNxtAD('AccountDetail')))) <=$(=date($(vEndDateNxtAD('AccountDetail'))))'

Still the values are not getting changed for the date dimension (Action_due_date)

Thanks in advance