topic Re: how to use variable value in double quotation in QlikView

how to use variable value in double quotation

mrbqlik2009 — Fri, 11 May 2018 18:14:35 GMT

Hi,

I have an expression such as this:

sum({<SaleCalendarYear={$(vPreviousYear)},SaleMonthNumberOfYear={">=2<=2"}, SaleDayNumberOfMonth={">=1<=$(=vTodayDay)"}>} Price+Discount)

I use variable vTodayDay in double quotation.

but it not work.

How can i get variable value in double quotation?

vishsaggi — Fri, 11 May 2018 18:42:36 GMT

What is the value you have in your vTodayDay? May be try like

= sum({< SaleCalendarYear = {$(vPreviousYear)},

SaleMonthNumberOfYear = {">=2<=2"},

SaleDayNumberOfMonth = {"=$(='>='&1&'<='&$(vTodayDay))"}>} Price+Discount)

Just try

= sum({< SaleCalendarYear = {$(vPreviousYear)},

SaleMonthNumberOfYear = {">=2<=2"},

SaleDayNumberOfMonth = {">=1<='$(vTodayDay)'"}>} Price+Discount)

mrbqlik2009 — Fri, 11 May 2018 18:48:48 GMT

Thanks for your answer, but it not work.

vTodayDay is a number between 1 to 31.

vishsaggi — Fri, 11 May 2018 19:04:32 GMT

Is it possible to share your app you are trying this on for a quick look?

mrbqlik2009 — Fri, 11 May 2018 19:31:45 GMT

I solved the problem. Thank you.

vishsaggi — Fri, 11 May 2018 19:49:58 GMT

Ok. Can you post the solution and mark yours as correct and close the thread.