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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
vijetas42
Specialist
Specialist

Picking Up Values(Urgent)

Hi,

Can any one tell me how to take values within three months in first field first value & from another field last value?

Ex.-I am having data for months start value & End Value

Month   Start Value  End Value

April      100             200

May       150            130

June       120            100

and I want to pick values from qvd as for Quarter1 100 & 120 which is months start value & months end value
Thanks in advance.

Labels (1)
5 Replies
Not applicable

Could you be a little bit more specific please.

regards,

MT

vijetas42
Specialist
Specialist
Author

Actually my requirement is that, If I am having data monthly I have to calculate quarters & for that to calculate difference between values I have to take first start value of  starting month that is april & 100 and for end value ending month of that quarter that is june & end value 100

MK_QSL
MVP
MVP

Can you share sample data?

vijetas42
Specialist
Specialist
Author

please refer the original message I have shared sample data

rajat2392
Partner - Creator III
Partner - Creator III

See this thread, you can get the demo application..it is same as your problem....