Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Creating QVD's

Hi,

I am using the script to create a compact qvd and then use the date field as dimension to build a chart the chart show as in the attached file.

My client wants a dynamic functionality to select the date as either 1st, 2nd , 3rd or 4th of every month. Please suggest a way how this can be achieved.

Thanks in advance.

6 Replies

Re: Creating QVD's

What is your current expression? and just out of curiosity why is 03/02/2016 the first date? It seems all other dates are in order except this one. Is there a specific sorting you are using here?

Not applicable

Re: Creating QVD's

Hi sunny,

The expressions i am using in just sum(sales), The issue is with the script. And the 03/02/2016 is just a current date that is used. So that we show a comparison of today Vs 4th of every month. We just needed to change the 4th so that user may compare today with either 1st,2nd, or 3rd as well.

Re: Creating QVD's

I think you could simply use day(YourDateField) as DAY within a master-calendar: How to use - Master-Calendar and Date-Values.

- Marcus

Not applicable

Re: Creating QVD's

Hi marcus,

We dont have any calender field in this, Please go through the attached document.

Re: Creating QVD's

You wrote:

My client wants a dynamic functionality to select the date as either 1st, 2nd , 3rd or 4th of every month.

Is this logically different to day(date)? And for many calculations/matchings is the use of a calendar helpful.

- Marcus

Not applicable

Re: Creating QVD's

Well marcus actually we have a date in the final app but when you will see the script in the attached file we are picking on the qvd of 4th of every month so even if we use date we dont have qvd of that date in the final app. i hope this helps

Community Browser