topic Re: Single Quote in Set Expression in qliksense in App Development

Single Quote in Set Expression in qliksense

vaibhavb — Sat, 16 Nov 2024 19:03:28 GMT

Hi, I am new to Qliksense, I have string like :-

2019-2020,2018-2019,2017-2018

I want to convert to following format :-

'2019-2020','2018-2019','2017-2018'

Could you please let me how to achieve this in set expression.

Re: Single Quote in Set Expression in qliksense

Andy_ASDF — Mon, 24 Feb 2020 11:55:26 GMT

Not sure if i understand your question correctly, but i would try:

Sum({<Column = {'2019-2020','2018-2019','2017-2018'}>} YourValue)

Re: Single Quote in Set Expression in qliksense

vaibhavb — Mon, 24 Feb 2020 12:42:44 GMT

Thanks Andy for quick response,

What actually i want is, I have Filter Pane of Fiscal Year(Financial Year) and i can select multiple years at time(Attached Image - img_20200224.png).

After selecting Multiple years, Using GetFieldSelections(FiscalYear) i am getting value like : -

2019-2020,2018-2019,2017-2018

Please find attached image for the same (img_20200224(1).png)img_20200224(1)

Now i want to convert the output to following format using set expression :-

'2019-2020' , '2018-2019' , '2017-2018'

If any please let me know.

Re: Single Quote in Set Expression in qliksense

sunny_talwar — Mon, 24 Feb 2020 12:52:13 GMT

You can try this

=Chr(39) & GetFieldSelections(FiscalYear, Chr(39) & ',' & Chr(39), 1000) & Chr(39)

But why do you need this? Are ignoring all selections and are looking to allow selection in just FiscalYear? If that is the case, may be you need this

Count({1<FiscalYear = p(FiscalYear)>} Measure)