topic Re: data according to day wise in QlikView

data according to day wise

capriconuser — Wed, 13 Feb 2019 06:28:00 GMT

i have a data like this

date values

01-01-2018 5000

01-02-2018 4000

01-04-2018 6000

01-08-2018 7000

02-01-2018 5000

02-12-2018 6000

and so on data like this

now i want when i select month from filter i want data according to days like this

Branch Month

abcbrach jan 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

5000 4000 6000 7000

how i do this but this seems like long table so is any other possibilities for this if not then i how i get above data format ?

Re: data according to day wise

swapniltaz — Wed, 13 Feb 2019 06:39:00 GMT

Hi ,

You can achieve this by creating following variables:

vDay = Date(Date#(date ,'MM-DD-YYYY'),'DD')

vmonth= Date(Date#(date ,'MM-DD-YYYY'),'MMM')

Use vMonth for filter and vDay as Dimension for u r chart

Re: data according to day wise

PrashantSangle — Wed, 13 Feb 2019 06:52:09 GMT

create master calendar.
for how to create master calendar, search on community , You will get multiple thread use appropriate thread

Regards,
Prashant Sangle