topic Re: Re: Combine and the dates and display the resuls in the Text object in QlikView

Combine and the dates and display the resuls in the Text object

Anonymous — Mon, 15 Sep 2014 07:19:29 GMT

Hi All,

Now i have date field as below and calls field, now i have to display the result as below,i want to show the one date and the count of calls as 20,can any one help on this.

Result:

Date Calls

1/1/2014 20

Date Calls

1/1/2014 5

Thanks & Regards,

Sivakumar

Re: Combine and the dates and display the resuls in the Text object

MayilVahanan — Mon, 15 Sep 2014 07:21:41 GMT

Try like this

Date as Dimension

Sum(calls) as expression

Edit:

In text box:

='Maximum Date' & Date(Max(Date)) & '---------' & 'No of calls' & Sum(Calls)

hope it helps

Re: Combine and the dates and display the resuls in the Text object

tresB — Mon, 15 Sep 2014 07:23:07 GMT

Text box:

='Date : ' &dateField& Sum(Calls)

Select a date to get the output.

Re: Combine and the dates and display the resuls in the Text object

jagan — Mon, 15 Sep 2014 07:25:24 GMT

Hi,

Try like this

='Date : ' & Only(Floor(Date)) & chr(10) & 'Number of Calls : ' & Sum(Calls)

Hope this helps you.

Regards,

Jagan.

Re: Combine and the dates and display the resuls in the Text object

Mon, 15 Sep 2014 09:16:12 GMT

kindly find attatch file this may help you

Regards

fahad

Re: Combine and the dates and display the resuls in the Text object

Anonymous — Tue, 16 Sep 2014 04:40:54 GMT

Hi All,

Thanks for all your help now in the below case how can i do .

Date Calls

1/1/2014 5

1/2/2014 5

Result Should be :

Date Calls

1/1/2014 20

1/2/2014 10

can any one help on this.

Thanks & Regards,

Sivakumar

Re: Combine and the dates and display the resuls in the Text object

MayilVahanan — Tue, 16 Sep 2014 04:43:52 GMT

Try like this
Date as dimension

Sum(Calls) as expression.

Re: Combine and the dates and display the resuls in the Text object

tresB — Tue, 16 Sep 2014 04:45:06 GMT

Straight table:

Dimension: Date

Expression:=Sum(Calls)

Re: Combine and the dates and display the resuls in the Text object

jagan — Tue, 16 Sep 2014 04:49:52 GMT

Hi,

Use Straight Table and try like this

Dimension:Date

Expression: Sum(Calls)

Regards,

Jagan.

Re: Combine and the dates and display the resuls in the Text object

Anonymous — Tue, 16 Sep 2014 04:50:19 GMT

Hi Tresesco,

Its possible to display through code in the text object?

Thanks & Regards,

Sivakumar

Re: Combine and the dates and display the resuls in the Text object

Anonymous — Tue, 16 Sep 2014 04:51:10 GMT

Hi Mayil,

Its possible to display through code in the text object?

Thanks & Regards,

Sivakumar

Re: Combine and the dates and display the resuls in the Text object

jagan — Tue, 16 Sep 2014 05:07:23 GMT

Hi,

Use Straight table, it is difficult to manage in Text object, to get the Text object view do this

Chart Properties-> Expressions -> TotalMode -> Select No Totals

Chart Properties -> Presentation -> Select Supress Header Row option

Chart Properties -> Style -> Deselect Vertical Dimensions Cell Borders and Vertical Expression Cell Borders

Chart Properties -> Style -> Select Cell Borders Transparency as 100%

Chart Properties -> Caption -> DeSelect Show Caption option

Hope this helps you.

Regards,

Jagan.

Re: Re: Combine and the dates and display the resuls in the Text object

tresB — Tue, 16 Sep 2014 05:22:13 GMT

Possible. But that would not be a dynamic solution. When your number of days would increase, you have to again work on for that to be displayed. Hence, output in text object might not be a good option.

See attached sample qvw.

Re: Re: Combine and the dates and display the resuls in the Text object

anbu1984 — Tue, 16 Sep 2014 05:55:35 GMT

Possible in text box. Check this

Re: Re: Combine and the dates and display the resuls in the Text object

anbu1984 — Tue, 16 Sep 2014 06:01:24 GMT

Without group by in Load