topic Re: Regarding Selection in QlikView

Regarding Selection

sarfaraz_sheikh — Mon, 10 Nov 2014 06:21:26 GMT

Hi All,

I want to extract the data in such way that ..i.e

Suppose i have below below data

Year Month Day

2014-2015 Nov 1,2,3,4,5,6,7,8,9

Now i want to extract the data till 7 Day.....I do not want 8,9 Day Data in mm Exel file ....How can acheive the same ..

Please help its urgent ...

Sarfaraz

SergeyMak — Mon, 10 Nov 2014 06:25:46 GMT

Hi,

It looks like "below data" is not enough.

Only if you need

LOAD

Year,

Month,

LEFT(Day, 13) AS Day1;

Could you give us more data?

Regards,

Sergey

sarfaraz_sheikh — Mon, 10 Nov 2014 11:33:10 GMT

Hi ,

As per below image ...I do not want 17 Day related data .. I just want 5 ,7,13 data whenever i will click on Sep .

How i can achive this ...can anybody help

Sarfaraz

SergeyMak — Mon, 10 Nov 2014 15:14:12 GMT

Can you share your app and source... I can't catch why you don't need in the first case more then 7 and in the second case you don't need 17...

What is your business requirements?

Regards

Sergey

Mon, 10 Nov 2014 15:22:32 GMT

pls explain little bit clear