topic Re: How to write an expression? in QlikView

How to write an expression?

Tue, 24 Mar 2015 08:37:04 GMT

I am new to Qlikview and am stuck with a problem. All my other graphs uses specific dates except for 1 graph which uses date range. So I created a new variable called Date (date).

I have 4 products A, B, C and D

I want to display a straight table with newly created date variable Date(date) of the relevant Product or Products that are being selected. For example, if Product A is selected, Date (date) for Product A is displayed. If Product B and A is selected, the Date (date) for Product A and B is selected. If 3 products selected , for example, Product A, B, D etc, then Date (date ) for Product A, B and D will be displayed.

How should I write the expression.?

Can someone please help?

Re: How to write an expression?

Tue, 24 Mar 2015 08:43:00 GMT

hi,

take straight table

dim product

exp only(Date)

-or-

=sum(num(Date(date,'dd-mm-yyyy')))

& properties>number>select number format setting>Date with format DD/MM/YYYY

Re: How to write an expression?

datanibbler — Tue, 24 Mar 2015 08:43:44 GMT

Hi Florence,

can you elaborate a bit on that? I don't quite understand what it is you're trying to achieve.

So you have four products and every product has exactly one date associated with it?

Do you just want to display those dates acc. to the selection or do you want to make a graph of that?

Are there any kind of events attached to those products that you want to display?

Do you have some kind of master_calendar in your app? That makes creating different graphs with some date_dimension easier in general.

Best regards,

DataNibbler

Re: How to write an expression?

anbu1984 — Tue, 24 Mar 2015 08:47:39 GMT

Set date variable to Date(Max(date))

Expr: $(vDt) //vDt is date variable

Re: How to write an expression?

Tue, 24 Mar 2015 08:55:39 GMT

The problem does not lies with the writing of the expression for the date range, the problem here lies with an expression to show the selected product. There is already a date varaible being created for date range:=if(Date >=vMinSelectedDateNews and Date <=vMaxSelectedDateNews, Activity_News)

I believe that this expression for date range is correct.

Now I need to write an expression to show dates of the selected product (s)

Re: How to write an expression?

Tue, 24 Mar 2015 08:59:16 GMT

Yes you are right.

Each product has one date associated with it. So for example, I select February 2014's data, the news for February 2014 (within this month) will be shown. For this function, I have already had an expression in place, named Date (date):

=if(Date >=vMinSelectedDateNews and Date <=vMaxSelectedDateNews, Activity_News)

Now I need to write another expression to show the dates for the selected product I selected.

For example, if Product A is selected, Date (date) for Product A is displayed. If Product B and A is selected, the Date (date) for Product A and B is selected. If 3 products selected , for example, Product A, B, D etc, then Date (date ) for Product A, B and D will be displayed.

Re: How to write an expression?

Tue, 24 Mar 2015 09:26:52 GMT

Hi Florence

try like this

Dimension : Product

Expression : sum(Max(Date)

Change the format of your date as per your data it can change in the number Tab.

Re: How to write an expression?

Tue, 24 Mar 2015 09:51:02 GMT

Hi Raja

I tried, but it says error in calculated dimension

Re: How to write an expression?

Peter_Cammaert — Tue, 24 Mar 2015 10:27:43 GMT

If you want the dates displayed in a text box (for example), you can use this expression:

=concat(Date, ',')

otherwise, it would be good if you could post an example QVW document.

Best,

Peter