topic Re: How to get correct data? in QlikView

How to get correct data?

Mon, 17 Feb 2014 14:16:10 GMT

Hi,

Is it possible to create

1) How many organisations there are per week?

2) Organisation split per week?

I tried but it seems I have doubt on result. Please help with correct expressions?

Thanks.

Re: How to get correct data?

Mon, 17 Feb 2014 14:25:21 GMT

Do I need to use Count(Distinct(organisation)) instead of Count(Distinct(StudentID))

Re: How to get correct data?

giakoum — Mon, 17 Feb 2014 14:28:48 GMT

yes you should, and week as dimension and not organisation.

You also have time in your date field, so you need to ceil it for example to get rid of time. That is why your date field does not match the calender date you are using.

Re: How to get correct data?

Mon, 17 Feb 2014 14:32:29 GMT

Thanks. If I want to show the information in table and graph means. could you suggets will Pivot and Bar suits or Pivot and Line chart?

Re: How to get correct data?

giakoum — Mon, 17 Feb 2014 14:33:58 GMT

Bar chart sort by count organisation desc would be my choice

Re: How to get correct data?

Mon, 17 Feb 2014 14:36:16 GMT

Thakns. Actually I have to show

a)No of organisations per week

b) organisation split per week

If I want to display organisation on vertical axis how can I do this?

Re: How to get correct data?

giakoum — Mon, 17 Feb 2014 14:41:33 GMT

try a grid chart with wee, organisation as dimensions and Count(Distinct(organisation)) as expression. For the organisation split per week, maybe a stacked bar chart would be a good choice.

Re: How to get correct data?

Mon, 17 Feb 2014 14:43:08 GMT

Thanks. That means do Ineed to do two charts. If so will the dimensions and expressions are same for two charts?

Re: How to get correct data?

giakoum — Mon, 17 Feb 2014 14:47:43 GMT

Depending on your customer needs, yes it will be 2 charts. Expression may be the same, just tick relative in the split one. But you need to try it out yourself and decide what suits your needs.

Re: How to get correct data?

Mon, 17 Feb 2014 14:50:47 GMT

please find attached when i use grid chart it is showing ...

Re: How to get correct data?

giakoum — Mon, 17 Feb 2014 14:56:15 GMT

if x axis is week, then that is what it should be showing

count of organisation for each week you asked for. Just order week correctly. if your data expands multiple years, then maybe you should use year_week instead of week only.

Re: How to get correct data?

Mon, 17 Feb 2014 14:57:47 GMT

How can I show year_week?

Re: How to get correct data?

giakoum — Mon, 17 Feb 2014 14:59:03 GMT

you have WeekYear in your calendar...

Re: How to get correct data?

Mon, 17 Feb 2014 15:01:37 GMT

ok yes I have and I used the same and again the same layout showing. Is there any other way I can display this in very visual manner?

Re: How to get correct data?

giakoum — Mon, 17 Feb 2014 15:06:04 GMT

try from the available chart types and determine based on your needs. A stacked bar chart would also be a good choice. Try, practice makes perfect

Re: How to get correct data?

Mon, 17 Feb 2014 15:08:39 GMT

Thanks and if I want to show the trends of weeks data will the below expression work?

avg({<Week={"<=$(Max(Week))"},Week={">$(=max(Week)-1)"}>} organisation)

Re: How to get correct data?

giakoum — Mon, 17 Feb 2014 15:11:38 GMT

did you try it? You cannot compare month with week. But anyway, I would use trendlines instead. It is a built in functionality.

Re: How to get correct data?

Mon, 17 Feb 2014 15:13:14 GMT

Could I know what is the difference as I haven't observed any difference after using this.

Re: How to get correct data?

giakoum — Mon, 17 Feb 2014 15:19:25 GMT

you most likely are not using it correctly. See the manual for more help on the topic.

See also attached example, but it will not help unless you read the theory behind it first.

Re: How to get correct data?

Mon, 17 Feb 2014 15:21:40 GMT

Thanks. Yes I can able to see the differences as when I made exponential and there is a line showing at 1.0. But i am worrying only with the layout of the chart item.