topic Dimension Values with Condition in QlikView

Dimension Values with Condition

tresB — Mon, 29 Nov 2010 06:05:22 GMT

Hi All,

I am short of idea, please help with your productive brain. i have some claims nos with multiple trasaction dates. i will have to calculate the current status(from status field based on Maximum transaction dates). then i will have to show those CLAIMS whose current status is say 2 .

So basically its filtering. Can't do at backend because its selection dependent(for till date analysis).

Thanks&Regards,

tresesco

Dimension Values with Condition

sunil2288 — Mon, 29 Nov 2010 07:20:12 GMT

Hi Tresseco,

Try this

=count({<[Claim no.s]>}distinct(@_Transdate)) as status

Regards

Sunil

Dimension Values with Condition

tresB — Mon, 29 Nov 2010 07:55:16 GMT

Thanks Sunil for your response. I probably could not explain properly wht i want. please find the sample data attached. Here for selection assume that the max year selected is 2003. then for the current status, ID-1 status would be 2 (corresponding to max date -2/2/2002), similarly for Id - 2 current status 3, and for Id -3 it is 2.

Now at the front end i want those Ids whose current status <>3 (as dimension in chart). Everything should be at the front end.

Once again. Thanks for your time

Dimension Values with Condition

sunil2288 — Mon, 29 Nov 2010 08:10:53 GMT

Hi Tres,

At first you need to create a variable & an input box .This variable you need to use in the set expression like this

count( {$<ids,var1<=year>},distinct(transdate))

here is year=year(transdate)

Regards

sunil

Dimension Values with Condition

tresB — Mon, 29 Nov 2010 09:57:14 GMT

Please go through it, if this can give you a better idea about what i want. Ids	Dates	Status	Amount
1	1/1/2002	1	100
1	2/2/2002	2	200
1	1/1/2001	3	300
2	3/3/2002	1	100
2	2/3/2002	2	200
2	4/2/2002	3	1000
3	10/10/2002	1	2000
3	11/10/2002	2	100
3	1/1012010	3	1000	This would not be counted in current status as the selection is assumed 2003

Desired output format

Dimension(Id)		Sum(Amount)
1
3
2	2' won't appear because its CURRENT STATUS is '3'

Thanks.

Dimension Values with Condition

tresB — Tue, 30 Nov 2010 10:08:21 GMT

Have not i been able to clear my problem ? Thanks for your attention.

Dimension Values with Condition

Wed, 25 Jan 2012 20:56:04 GMT

Hi İ have same problem with you could you find the solution

Re: Dimension Values with Condition

Wed, 25 Jan 2012 22:03:07 GMT

I hope that can be usefull.

But in your exemple Id 3 have a date in 2010... I did'nt understood why you bring it because it's the max date but it's not status = 2... Oo So I'm probably wrong.

Eva