topic Re: Using alternate states in Dimensions in QlikView

Using alternate states in Dimensions

Anonymous — Tue, 04 Aug 2015 08:49:24 GMT

Hello,

i need to use use alternate states in dimensions or alternatively without an operation like sum, count,etc..

Is it Possible?

Thanks in advance,

Regards

Re: Using alternate states in Dimensions

Gysbert_Wassenaar — Tue, 04 Aug 2015 08:51:23 GMT

Why? What are you trying to do?

Re: Using alternate states in Dimensions

Anonymous — Tue, 04 Aug 2015 08:58:48 GMT

i make a table like this, that doesn't have espression ( Rating Fitch is a simple dimension)...but i need that Rating Fitch is variable depending from DATE state 1 and DATE state 2 so as to be able to compare the trend...

Re: Using alternate states in Dimensions

Gysbert_Wassenaar — Tue, 04 Aug 2015 09:03:50 GMT

Your screenshot looks like a pivot table with two dimensions and one expression. And I still don't understand what you're trying to do. Perhaps you can give an example of the source data and the result table.

Re: Using alternate states in Dimensions

Anonymous — Tue, 04 Aug 2015 10:10:34 GMT

I have 4 fields: Bank Group, Bank Group Country , [Rating FITCH], and the Date pertaining to the rating.

I need to compare the trend of Rating FITCH: for example i want see in ste same table Rating Fitch od 1/01/2015 and the

Rating Fitch of 01/05/2015...I think it was possible with an alternate state

result table:

Bank Group	Bank Group Country	[Rating FITCH] State 1	[Rating FITCH]State2
AGENCIA DE FOMENTO DO PARANÁ	Brasile	BBB	BBB
AGRICULTURAL BANK OF CHINA	Cina (Rep. Popolare)	A+	A+

Date State 1	01/01/2015
Date Sate 2	01/05/2015

Re: Using alternate states in Dimensions

Gysbert_Wassenaar — Tue, 04 Aug 2015 10:19:45 GMT

Sure, that shouldn't be a problem. Use two expressions:

only({State1}[Rating Fitch])

only({State2}[Rating Fitch])

Re: Using alternate states in Dimensions

Anonymous — Tue, 04 Aug 2015 10:22:08 GMT

thanks a lot!!!