Hyy,
In Qliksense created a Filter Pane that shows data when we select a particular year with month.
And that selection field will show data based on 2 columns ...
One is Timestamp column(which has format-yyyy-MM-DD)and other is like nrml column ... (format-yyMM)
Already created a syntax for this.. but the dropdown showing date also along with Year&Mnth..
Syntax:
->date(RangeMax(floor(Timestamp) , Rangemax(floor(Field)))).
But in dropdown of filter pane it showing date alsoo... I don't need date... It should only show year&Mnth....
Ex: User should be able to get that year,months data considering that 2 columns if they click on particular year/ month...
Can anyone help..much appreciated
Thanks...