I recommend you to create some kind of date/period field that has the granularity you are looking for. It is hard to plot weekdays when your most granular period is month.
When you have done that you could create hiearchical dimentions that does the drill down functionality that you are searching for.
Create a hieararchic dimension. The language might be strange, but the layout should be similar in your environment.
The script below was used to create year and month from your data table.
Month(%Period) as Month,
Year(%Period) as Year,
date#([Year-Month],'YYYY-MM' ) as %Period,
(html, codepage is 1252, embedded labels, table is @1);
I have follow you step change my loading script to data table.
1.The issue is not we deep down to period it is displaying "yes, no" how can we change to week, suppose below img is 11/1/18 to 12/1/18 now its should display in other chart as November month of 4 week only?
for example : 11/4, 11/11, 11/18, 11/25 in X axis ? now its displaying yes, no?
2.other question i need to do same thing with days (if you choose 11/4 week then display then display 7 day from 11/4 to 11/10 in X axis )
In your transaction table where you have the timestamp create a new field called %date like the script below.
date(SubField(Timestamp, ' ',1)) as %date
Then, after you created this field, run the code seen below to create an master calendar.
for each _date in FieldValueList ('%date')
'$(_date)' as %date,
year('$(_date)') as Year,
month('$(_date)') as Month,
Week('$(_date)') as Week,
Weekday('$(_date)') as Weekday
You can expand the fields in this calendar according to your own need ant taste. (Google search for master calendar Qlik to find other more detailed master calendars.
Take a look at my earlier comment on how to create drill down dimensions. Be aware when using week in drill down from month, a week can belong to two months.