topic Re: set Analysis in QlikView

set Analysis

Mon, 06 Jan 2014 12:41:48 GMT

Hi everyone,

I have to display data on hourly basis .Ihave taken hours as dimension and Expression is

=if(day=day(today()),count(number)) it is not working

if day is today then i should count Ticket number and show the data.Please help me

Regards,

Divya

Re: set Analysis

Mon, 06 Jan 2014 13:11:23 GMT

Take today() in variable and try..

= if(1/6/2014=$(vToday),1)

vToday is Today()

And also check the date format....

Selva...

Re: set Analysis

simondachstr — Mon, 06 Jan 2014 13:16:31 GMT

Day() formats to numbers 1-7. Maybe your day field though are characters 'Mo', 'Tue' etc.?

A small but very common error.

Re: set Analysis

preminqlik — Mon, 06 Jan 2014 13:46:31 GMT

hi try this

count(if(Date=date(today()),Number))

hope this helps you

Re: set Analysis

preminqlik — Mon, 06 Jan 2014 13:59:20 GMT

or count({{<Date={'$(=date(today()))'}>}Number)

Re: set Analysis

Tue, 07 Jan 2014 06:17:42 GMT

Hi,

Days field contains 1 to 31 numbers only not in text format

Re: set Analysis

adnan_rafiq — Tue, 07 Jan 2014 06:28:43 GMT

if you use Date(Today) it will return value like 1/6/2013 which will be re evaluated to 1 divided by 6 divided by 2013 due to $ expansion (you can say it a bug). Use num(Today() and make sure in script you load DateField as number

by using num(DateField) as DateField

Re: set Analysis

Anonymous — Tue, 07 Jan 2014 06:35:20 GMT

Create the numeric value of your date field in script to ignore any format issues.

via, num(Date_field) as Date_field_num.

Now use this field in expression in set analysis

count({$<Date_field_num={$(=num(today()))}>}Number)

Hope it solves the problem...

Regards

Nitin

Re: set Analysis

jagan — Tue, 07 Jan 2014 06:48:40 GMT

Hi,

Can you attach some sample file.

Regards,

Jagan.

Re: set Analysis

Tue, 07 Jan 2014 07:05:37 GMT

Hi,

PFA

Regards

Divya

Re: set Analysis

Tue, 07 Jan 2014 07:24:56 GMT

Hi,

I tried it is not working .help me

Regards,

Divya

Re: set Analysis

Tue, 07 Jan 2014 07:30:44 GMT

Your application is failed to open can you attach the same one more time

Re: set Analysis

Tue, 07 Jan 2014 07:39:30 GMT

hi ,

reattaching ... PFA

Re: set Analysis

jagan — Tue, 07 Jan 2014 07:44:33 GMT

Hi,

In your script replace this

Timestamp(opened_at,'hh') as Hours with Hour(opened_at) as Hours

and in your variable set Vtoday =today() and use this expression in chart

=count({<date={'$(Vtoday)'}>}number)

Regards,

Jagan.

Re: set Analysis

MK_QSL — Tue, 07 Jan 2014 07:45:28 GMT

Try this...

=Count({<date = {"$(=Date(Today()))"}>}number)

Re: set Analysis

Tue, 07 Jan 2014 07:53:29 GMT

Hi Manish I tried it is not working

Re: set Analysis

MK_QSL — Tue, 07 Jan 2014 08:01:27 GMT

What is the total count number for today... I have used the same and getting answer

Re: set Analysis

manideep78 — Tue, 07 Jan 2014 08:18:32 GMT

Hi Divya,

Please try the below expression

=Count(If(day(Today()),number))

Re: set Analysis

Tue, 07 Jan 2014 09:24:38 GMT

Hi,it is working.Thank you