topic Re: using variable in expression in charts in QlikView

using variable in expression in charts

sakshikaul — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I want to write an expression using variables start_date and end_date as shown in image

I want to show sales between the start_date and end_date. Both start_date and end_date are variables and these are text boxes

Now want to call both the variables in chart by writing expression using set analysis.

I want when user will select an event and will select a corresponding even date (lastDate)

now if user wants to know the sales on pre event date ie sales before 10 days with respect to selected date

and after once we get the date in text box that date will become starting date and last date will be as an event date

so I need to write an expression for start date and end date in pivot chart. How to write an expression?

Re: using variable in expression in charts

Anil_Babu_Samineni — Mon, 05 Nov 2018 09:20:37 GMT

Not sure, Why you required to create many threads for single issue?

How to use a variable in expression in charts

how to write an expression for date range using variable

using variable in expression in charts

Instead, can you maintain one thread. cua Please look this.

Re: using variable in expression in charts

sakshikaul — Mon, 05 Nov 2018 09:36:19 GMT

Hey

When I attached the document, It was not responding so I thought the file was not attached hence I made a new thread for the same. I will take care of this in future.

Re: using variable in expression in charts

Anonymous — Mon, 05 Nov 2018 18:40:35 GMT

Thanks Anil and Sakshi.

I am locking this thread and another of the duplicates that has the fewest responses.

I will keep this thread open for this issue: how to write an expression for date range using variable

Best,

Jeremy

Qlik Community Team