topic Re: Table with 2 State as dimension in QlikView

Table with 2 State as dimension

Wed, 25 Nov 2020 16:16:04 GMT

Hi, !

I try to compare two differents selections of the same field.

For that I build two table with two differents states, that work well but now i'm trying to keep only one table.

Which looks like that :

	lib	value T	value	%
State 1	B	121	761	0.53
State default	A & B	221	761	0.49

I dunno how I can make a dimension with several several state or even if it's possible.

If someone have any tips it would be great!

I made a small application, which could help you to understand my request.

Re: Table with 2 State as dimension

avinashelite — Tue, 09 May 2017 08:48:24 GMT

Handel this in the set analysis ...try like below examples

[State Identifier] and ::

Function({[state_identifier1] <field_name2= [state_identifier2]::field_name3>}field_name)

Set values for field_name2 within [state_identifier1] basedon values of field_name3 in[state_identifier2]

e.g. sum({Group1} <Year=$::Year> Sales)

e.g. avg({MarketDev} <Year={BaseLine}::Year,Category={Global}::ProductCategory>SalesLeadTime

Achieving the same thing with 2 differentsyntax:

Option 1 - sum({[Group 1]<Region =$::Region, [Sales Rep] = $::[Sales Rep], Path = $::Path, Year= $::Year, Quarter = $::Quarter, Month = $::Month>} Sales)

Option 2 - sum({$<[Product Sub Group]= [Group 1]::[Product Sub Group] >} Sales)

Re: Table with 2 State as dimension

Tue, 09 May 2017 10:02:50 GMT

Thanks for your quick answer,

It seems you didn't understund my request, probably due to my poor english.

Tell me if i'm wrong, but your solution allow to set one field at state1 with the value of the same field at state2.

I'm currently trying to show Expressions at State1 AND State2 on differents row of the same table.

Re: Table with 2 State as dimension

avinashelite — Tue, 09 May 2017 10:13:30 GMT

Sorry got your requirement , according to me its not possible because we don't have a function to get the current selection of a field based on the Alternate states so that we could enable the field based on the State selections ...

Re: Table with 2 State as dimension

tresB — Tue, 09 May 2017 10:39:18 GMT

Like this?

Re: Table with 2 State as dimension

avinashelite — Tue, 09 May 2017 11:13:28 GMT

Woo!!

tresesco‌ nice your handling this using value list but what if we select A in both the States ? it will count A twice rite

Re: Table with 2 State as dimension

Tue, 09 May 2017 12:05:00 GMT

I just changed few things, and It's work perfectly.

Thank to both of you !