topic Re: Create Date Parameter in App Development

Create Date Parameter

snehasimha — Sat, 12 Feb 2022 11:16:41 GMT

Dear All

I need to create two date Parameters ie From and To date using the functions. which will give me the Sales for the chosen years. The free trial of the App version is ceased and hence and i can only access the same in cloud.Request to please give me a step by step creation of the same. (using functions) no scripts please.

Also i need to calculate the Sales Growth for the Date parameters created.

Regards

Sneha Simha

Re: Create Date Parameter

rubenmarin — Sat, 12 Feb 2022 11:41:01 GMT

Hi, you can add two variable objects for the user to inser fron and to dates, or use a celndar object with ranged selections.

The expressions that uses variables could be: Sum({<DateField={">=$(FromVariable)<=$(ToVariable)"}>} Sales)

And with calendar you can use a simple: Sum(Sales)

About the growth... calculated based on what values? it would be better if you post sample data and the expected result.

Re: Create Date Parameter

snehasimha — Sun, 13 Feb 2022 13:35:38 GMT

I cant possibly share the data, i want two date parameters say one for last year and one for this year.The Growth should be calculated based on the Sales for both the years.

Without the code , is there a way to get the calendar generated like in Tableau

Regards

Sneha Simha

Re: Create Date Parameter

rubenmarin — Sun, 13 Feb 2022 16:39:42 GMT

Hi, I don't know Tableau, If you load ata using data manager a calendar is created automatically from the dates fields, one of this fields is the year.

Having Year as field to make selections, the expression could be:

(Sum({<Year={"$(=Max(Year))>} Sales)-(Sum({<Year={"$(=Min(Year))>} Sales))/Sum({<Year={"$(=Min(Year))>} Sales)

Re: Create Date Parameter

snehasimha — Mon, 14 Feb 2022 03:15:23 GMT

Hi
My data is an excel sheet and I am using
a trail Version on the cloud. Hence I am finding it a little difficult. If
it's possible request you to kindly guide me step by step please.

--

This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they are
addressed. If you have received this email in error, please notify the
sender immediately by email or delete this email from your system. If you
are not the intended recipient, you are notified that disclosing, copying,
distributing or taking any action in reliance on the contents of this
information is strictly prohibited. The opinion expressed in this mail is
that of the sender and does not necessarily reflect that of Titan.

****

WARNING: Despite best possible precautionary measures taken by Titan
Company Limited, computer viruses can be transmitted via email. The
recipient should check and scan this email and any attachments for the
presence of viruses. Titan Company Limited accepts no liability for any
damage caused by any virus transmitted by this email.****

*******************************************************************************************************************

Re: Create Date Parameter

rubenmarin — Mon, 14 Feb 2022 07:38:31 GMT

Hi, there are different ways to load data, ther is a data manager, where you can select a column data, mark it as date field, and the calendar is created autoamticaly. Maybe you are no using this option because usually date fields are automaticaly marked.

The othre option is script editor, this is more flexible but you need to work with the script, in this case to create a year field from data you only need to a row:

LOAD <List of fields>, Year(DateField) as Year // this is the new row to add FROM ...

If doesn't works I will need more info, post your script, or some dummy data, or something... there are a lot of different ways to do the same, you need to provide more info about your current attemps to make this work..

Re: Create Date Parameter

snehasimha — Mon, 14 Feb 2022 08:55:23 GMT

Hi
I will send my data in sometime, please do help me. I will change the
required fields and send across to you

--

This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they are
addressed. If you have received this email in error, please notify the
sender immediately by email or delete this email from your system. If you
are not the intended recipient, you are notified that disclosing, copying,
distributing or taking any action in reliance on the contents of this
information is strictly prohibited. The opinion expressed in this mail is
that of the sender and does not necessarily reflect that of Titan.

****

WARNING: Despite best possible precautionary measures taken by Titan
Company Limited, computer viruses can be transmitted via email. The
recipient should check and scan this email and any attachments for the
presence of viruses. Titan Company Limited accepts no liability for any
damage caused by any virus transmitted by this email.****

*******************************************************************************************************************

Re: Create Date Parameter

snehasimha — Mon, 14 Feb 2022 11:45:50 GMT

Hi Rubenmarin

Enclosed my sample data.Please do help me.Enclosed is the screen shot as to how I want my dates and the below tabulation comprises Values and Growth based on the dates above.

Regards

Sneha simha

Re: Create Date Parameter

chris_djih — Mon, 14 Feb 2022 13:36:39 GMT

You are may looking for the date picker.
You can find it under custom objects> Qlik Dashboard bundle:

Re: Create Date Parameter

rubenmarin — Mon, 14 Feb 2022 19:49:00 GMT

Hi, attached there is a sample to do this for sales, I'm using two date pickers as @chris_djih suggest.

Period 1 to default state and period 2 assigned to 'Comp' altern states.

You can create altern states in master items, this allows to use the same field with differnt slections

To use selctions of the Comp alternstaet you can use set analysis, so the epxression would be:

- Period 1: Sum(SalesValue)

- Period 2(using altern state): Sum({Comp} SalesValue)

To calculate the group i'm using Column() function, you can also use column labels, master items or write the full expression: (Sum({Comp} SalesValue)-Sum(SalesValue))/Sum(SalesValue)

Re: Create Date Parameter

snehasimha — Tue, 15 Feb 2022 08:51:53 GMT

Hi Rubenmarin

This was exactly what I was looking for , thank you so very much but the file I am unable to view is it possible for you please create it again sending the screen shots.Request you to do so , as I am unable to bring to Date pickers in the same sheet and also unable to select Date range for the years 2019-20 and 2020-2021.

Regards

Sneha Simha

Re: Create Date Parameter

rubenmarin — Tue, 15 Feb 2022 09:18:43 GMT

Hi, why can't you open the file? it's a qvf, you can import it in you deployment of qlik sense.

There is not really more to post than in my previous post.

This is the sheet with the objects:

And Period 2 config to assign the selettor to the altern state