Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

capriconuser
New Contributor III

Data according to day wise

i have a data like this 

 

date                                    balance                    code

1-jan-2018                       500                            abc

1-jan-2018                       90                           def

2-jan-2018                        600                          def

3-jan-2018                       900                           rst

6-jan-2018                     1200                           kdsg 

10-jan-2018                   1500                        sdfg

now i want these balances per day wise means i want to apply filter of month i.e. when i click on jan month then all the dates should be on table like this is i want 

code     day1 day2   day3  day4  day5  day6  day7   day8 day9 day10... so on 

abc        500 

def          90     600

rst                                 900

kdsg                                                                 1200

sdfg                                                                                                                   1500

 

 

how i get this ?

6 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Data according to day wise

Use the Day() function to create a field for the day of the month of the date:

LOAD
date,
Day(date) as Day,
.... other fields ....
FROM .... source ....

Once you have that you can create a pivot table chart object with code and Day as dimensions.

talk is cheap, supply exceeds demand
capriconuser
New Contributor III

Re: Data according to day wise

@Gysbert_Wassenaar  i did that but this shows that time is in 1 column where i want to contribute that time according to day wise please check image 

IMG_20190214_140112.jpg

 

like this what i want

branch update_month  update_day     1              2             3

abc         Jan                                                    3:00       4:00        9:00     

MVP & Luminary
MVP & Luminary

Re: Data according to day wise

Looks like you're using Time as a dimension instead of as a measure.


talk is cheap, supply exceeds demand
capriconuser
New Contributor III

Re: Data according to day wise

yes i am using time as dimension .. if i use time as measure then how i  use .. means i directly call time field in measure or there is some calculation ?

MVP & Luminary
MVP & Luminary

Re: Data according to day wise

If there's only one Time value per combination of dimension values then you can use sum(Time) or Only(Time) or Avg(Time) or Max(Time) or Min(Time). They'll all return the same result if there's only one Time value.


talk is cheap, supply exceeds demand
capriconuser
New Contributor III

Re: Data according to day wise

ok 

 

and also i want to tell this there is 30 /31 days in a month so it looks like long table so is there any alternative to show 30/31 days in any other perspective?