Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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 ?


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

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