topic Re: how to use in QlikView

how to use

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

Hi all,

Miguel Angel Baeyens de Arce

Bala Bhaskar

i want to use variable in alternate state expreession below i tried but no luck how to use?

=Sum({<[Name] -= {"=len(trim([Name]))=0"},[L1]=$::[L1],[SRn]=$::[SRn],FormatId=$::FormatId>}[Amount])
/$(vFormatId)

variable is not workibng here but when i hardcode the value its working

if i use variable data not showing anything

//1000000
//$(vFormatId)
//only({<FormatId=$::FormatId>}FormatId)

variable: vFormatId=FormatId

format id is field and having values 1000000,1000

Re: how to use

BalaBhaskar_Qlik — Mon, 27 Aug 2018 16:17:06 GMT

May be try like this:

1. Change variable like:

vFormatId = Only(FormatId); use this in expr as: $(vFormatId)

2. only({<FormatId=$::FormatId>}Amount)

3. Aggr(Only({1<FormatId = p(FormatId)>}Amount),Amount)

Re: how to use

vishsaggi — Mon, 27 Aug 2018 16:27:20 GMT

variable cannot hold multiple values at a time unless you use some Concat() or Aggregate functions like Min Max(). So when you divide sum()/$(formatid) what is the value you want to divide this by?

Re: how to use

soniasweety — Mon, 27 Aug 2018 16:33:37 GMT

formatid is a field having two values 1000 and 1000000

i want to divide the value sum()/1000 and 1000000

my report need to show millions and thousands when user selects thousands it should show thousands

and same for millions

Re: how to use

soniasweety — Mon, 27 Aug 2018 16:34:04 GMT

3 not working null it is showing

Re: how to use

soniasweety — Mon, 27 Aug 2018 16:36:54 GMT

Felip Drechsler

Marco Wedel

Sunny Talwar do you have any help on this?

Re: how to use

vishsaggi — Mon, 27 Aug 2018 16:40:49 GMT

‌so you have only two values in your field formatid 1000 and 100000. Why don’t you just use sum()/formatid did you try this way? Don’t use any variable.

Re: how to use

soniasweety — Mon, 27 Aug 2018 16:43:43 GMT

tried but its also showing nothing

Re: how to use

soniasweety — Mon, 27 Aug 2018 17:10:41 GMT

Hi Bala Bhaskar its not working i tried your 3 expressions

Re: how to use

sunny_talwar — Mon, 27 Aug 2018 17:17:50 GMT

So, FormatId is selected in the inherited state or another alternate state? The chart is in inherited state or Alternate State?

Re: how to use

soniasweety — Mon, 27 Aug 2018 17:20:23 GMT

yes sunny its in inherited state and table in different state

so now how can i do this?

Re: how to use

sunny_talwar — Mon, 27 Aug 2018 17:24:03 GMT

If you make selection in FormatId in inherited state, then may be try this

=Sum({<[Name] -= {"=len(trim([Name]))=0"}, [L1] = $::[L1], [SRn] = $::[SRn], FormatId = $::FormatId>}[Amount])/Only({$} FormatId)

Re: how to use

soniasweety — Mon, 27 Aug 2018 17:31:36 GMT

its giving values sunny let me test in the morning. thanks for the response.

Re: how to use

sunny_talwar — Mon, 27 Aug 2018 17:36:06 GMT

sounds good