Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
capriconuser
Creator
Creator

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
Gysbert_Wassenaar

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
Creator
Creator
Author

@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     

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
capriconuser
Creator
Creator
Author

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 ?

Gysbert_Wassenaar

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
Creator
Creator
Author

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?