Didn't understood your question. Can you elaborate little bit more
Great dreamer's dreams never fulfilled, they are always transcended. Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
i am trying to convert selected date in a sheet into a number, i can get selected date by using getselectedfield(date,',') now i want to convert into number.
Just Num(DateFieldName), assuming one has been selected this should work. If it doesn't, your "date" is probably a string rather than a date and needs to be converted using Date#().
i would like to store my current selected date values in a variable in numerical format (single value or multiple) so i can use that variable in Sheet action, currently i am using Getfieldselections(monthname), but the return i am getting is String value.
If your date value is actually a string and not an actual date-formatted date, you can use date#(). If your date is e.g. '2024-12-31' you can do this: num(date#('2024-12-31', 'YYYY-MM-DD'))
But that's kind of a sidenote. It seems that you are saying that you can have multiple selected different dates. In this case, getfieldselections(monthname) will result in a string like for example ''2024-12-31,2025-03-07' and you can't convert that into a number. I suppose that you want to convert it into a string with multiple numbers, something like '4711,4712'.
Maybe you could use concat(distinct num(monthname),',') instead of getfieldselections. Because just like @Or said, it sounds like you don't actually need GetFieldSelections() in this case.
i have multiple sheets, which have same type of fields and data only the group name is different, i have separated the sheets based on groups, when i select activity month (date field) and when i go to next group sheet i want to see same selection but for different group, even if i select multiple dates i should see multiple values selected in next sheet, also i when i land on any page by default it should select my reporting month which is previous month of current date. i am able to achieved all of this by storing my current selections in a variable, but only issue is when i select multiple dates and go to next sheet the selection automatically removed,
Are you using actions that are triggered on sheet opening, that modified the selections? (If you aren't, selections should not change just because you change sheet, uless sheets are in alternate states.) How are those actions defined?
I don't understand why you are storing your current selections in a variable - what is the purpose of that?
yes, i am using Sheet action for my all sheets, because when i open any sheet i want by default reporting date should be selected (like we are in March, my reporting month should be selected February) by default, similarly if i made changes in my date selection (like if i selected January or December and January both month) and if i move to different sheet my new selections should apply,
everything is working what i am expecting by storing selection values in a variable (GetfieldSelections(Fieldname,';') and in Sheet action i selected 'select value in a field' and in value field i mentioned the variable name, however my challenges are when i select multiple dates, that's where my sheet action does not work,
if i add multiple dates manually in numeric datatype in the variable it's working but when i use getfieldselections it doesn't work, i understand when i use getfieldselections it stores the values in string datatype.
Normally, without any sheet actions, selections stay with the user even when changing sheets. You can make selections on one sheet, go to another sheet and the same selections will still be there.
GetFieldSelections holds the current selections, and therefore your variable will change immediately when selections change. If your sheet action changes your selections, the variable will change accordingly.
It sounds like you need to take another approach. You could for example use if-statements to always use previous month in your calculations, unless there are selections made in the date fields. Or you could use a dynamic default bookmark that makes sure that the app opens with previous month selected, but after that it's up to what the users selects.
