topic Satate Issue in QlikView

Satate Issue

manoranjan_d — Wed, 19 Jul 2017 13:26:50 GMT

Hi all,

I have declared two state1 and state2 for the two list boxx of week_num1 and week_num2

in the straight table i have given 4 expresions, out of these 4 expression i have given 2 expresion for the state, remaining two expression dosen't required states

my requirement is to compare the week wise data in column wise

exp1 have state1

exp2 have state 2

exp3 is simply called the filed name

exp4 is simply called the field name.

now my requirement is not meeting, since i didn't give exp3 and exp4 with state.

how this can be resolved ?

Re: Satate Issue

manoranjan_d — Wed, 19 Jul 2017 13:34:11 GMT

that means

what is happening is that

my records getting duplicated

id	des	amt w1	base_amt w2	first name	last name
1	aaa	100	-	-	-
2	bbb	200	-	-	-
3	ccc	300	-	-	-
1	aaa	-	100	-	-
2	bbb	-	200	-	-
3	ccc	-	300	-	-
1	aaa	-	-	Mano	D
2	bbb	-	-	kriwin	S
3	ccc	-	-	kenniy	M

the first name and last name getting null but its being duplicated. this has to come in the w1 and w2

Re: Satate Issue

manoranjan_d — Wed, 19 Jul 2017 14:29:27 GMT

can any one reply me

Re: Satate Issue

Anil_Babu_Samineni — Wed, 19 Jul 2017 14:31:07 GMT

We don't know about Data model which you done. Will you able to provide sample inline memory or may be QVD;s >>

Re: Satate Issue

manoranjan_d — Wed, 19 Jul 2017 14:49:45 GMT

data model is single table only.

simple concept

out of 4 expression i given state for the exp1--state1 and exp2,--state2

remaining exp3 and exp4 are simply calling the field didnt assign the state