topic Re: Text object with a chart and Relative dates in QlikView

Text object with a chart and Relative dates

Thu, 12 Sep 2013 12:25:02 GMT

Hi,

i am attaching the screenshot of my requirements. Please tell me how to incorporate a chart within a text object as shown in the image. Also let me know how to add the past 30 days option which is on the right of the image shown.

Thank you.

Re: Text object with a chart and Relative dates

swuehl — Thu, 12 Sep 2013 12:52:31 GMT

Looks like this is a demo application that you may download from the demo site.

Then have a look on how they've designed the layout by examining the objects and their properties.

Re: Text object with a chart and Relative dates

MayilVahanan — Thu, 12 Sep 2013 12:56:14 GMT

You can able to find the solution by examining the objects and properties itself. I think they're text object and modified the font size

Re: Text object with a chart and Relative dates

Thu, 12 Sep 2013 12:58:50 GMT

It is a demo application , i have been trying to get the properties though. Couldnt figure it out. It would be of immense help if you let me know the procedure.In the sense, The whole procedure of adding the text object and the relative dates, Thanks in advance.

Re: Text object with a chart and Relative dates

MayilVahanan — Thu, 12 Sep 2013 13:05:25 GMT

Can you send the path where u get the file or post that file. Will check and let u know about that

Re: Text object with a chart and Relative dates

Thu, 12 Sep 2013 13:08:36 GMT

QlikView

This is the link of the Demo document. Thanks for the immediate response.

Re: Re: Text object with a chart and Relative dates

Josh_Good — Thu, 12 Sep 2013 15:11:42 GMT

A combination of several techniques are being used to achieve this effect. I would recommend you download the QVW from the demo site so you can see how it is all put together. Qlik Demos: See QlikView in Action | Demo.Qlik.Com

Here is a short summary of what is being done: A text object that says "Past 3 months" for example, has an action put on it that generates the correct search string to return the last three months. Today is Sept 12, 2013 and the date format in the app is 'MM/DD/YYYY' so in this case the correct string would be >=6/12/2013 applied to th

e Date field. In this particular app the developer decided to generate the date using a variable called 'vPast3Month'.

This link reviews how to select date ranges in general. It isn't exactly the same as what is being done the Log Analysis app but is similar.

Selecting Arbitrary Date Ranges