Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
manoranjan_d
Specialist
Specialist

Satate Issue

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 ?


Labels (1)
4 Replies
manoranjan_d
Specialist
Specialist
Author

that means

what is happening is that

my records getting duplicated

   

iddesamt w1base_amt w2first namelast name
1aaa100---
2bbb200---
3ccc300---
1aaa-100--
2bbb-200--
3ccc-300--
1aaa--ManoD
2bbb--kriwinS
3ccc--kenniy

M

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

manoranjan_d
Specialist
Specialist
Author

can any one reply me

Anil_Babu_Samineni
MVP
MVP

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
manoranjan_d
Specialist
Specialist
Author

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