topic Re: Data according to day wise in QlikView

Data according to day wise

capriconuser — Thu, 07 Feb 2019 06:24:59 GMT

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 ?

Re: Data according to day wise

Gysbert_Wassenaar — Thu, 07 Feb 2019 09:50:08 GMT

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.

Re: Data according to day wise

capriconuser — Thu, 14 Feb 2019 09:05:20 GMT

@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

like this what i want

branch update_month update_day 1 2 3

abc Jan 3:00 4:00 9:00

Re: Data according to day wise

Gysbert_Wassenaar — Thu, 14 Feb 2019 09:14:20 GMT

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

Re: Data according to day wise

capriconuser — Thu, 14 Feb 2019 09:21:09 GMT

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 ?

Re: Data according to day wise

Gysbert_Wassenaar — Thu, 14 Feb 2019 09:48:21 GMT

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.

Re: Data according to day wise

capriconuser — Thu, 14 Feb 2019 10:58:09 GMT

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?