Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please find the attached data and i have to write a set expression in qliksense for the trailing 12months,
here i don't have date in my data but only the months and year.
kindly provide the solution to the above query urgently
Year | Month | Unit Name | Sales |
2021 | 4 | B208+Chetak | 1891.18 |
2021 | 4 | GFPL-Mfg. | 499.54 |
2021 | 4 | GFPL-Trading | 180.39 |
2021 | 4 | FP | 1038.98 |
2021 | 4 | SKG | 1003.36 |
2021 | 4 | Vizag | 824.04 |
2021 | 5 | B208+Chetak | 1785.90 |
2021 | 5 | GFPL-Mfg. | 663.84 |
2021 | 5 | GFPL-Trading | 337.13 |
2021 | 5 | FP | 1180.61 |
2021 | 5 | SKG | 1116.52 |
2021 | 5 | Vizag | 773.98 |
2021 | 6 | B208+Chetak | 2183.78 |
2021 | 6 | GFPL-Mfg. | 610.22 |
2021 | 6 | GFPL-Trading | 273.13 |
2021 | 6 | FP | 1158.39 |
2021 | 6 | SKG | 1247.05 |
2021 | 6 | Vizag | 985.59 |
2021 | 7 | B208+Chetak | 1204.50 |
2021 | 7 | GFPL-Mfg. | 569.11 |
2021 | 7 | GFPL-Trading | 215.73 |
2021 | 7 | FP | 767.75 |
2021 | 7 | SKG | 1163.59 |
2021 | 7 | Vizag | 903.51 |
2021 | 8 | B208+Chetak | 2963.05 |
2021 | 8 | GFPL-Mfg. | 653.74 |
2021 | 8 | GFPL-Trading | 341.04 |
2021 | 8 | FP | 1181.80 |
2021 | 8 | SKG | 1388.25 |
2021 | 8 | Vizag | 1018.61 |
2021 | 9 | B208+Chetak | 2962.10 |
2021 | 9 | GFPL-Mfg. | 728.61 |
2021 | 9 | GFPL-Trading | 251.38 |
2021 | 9 | FP | 1312.39 |
2021 | 9 | SKG | 1405.85 |
2021 | 9 | Vizag | 1685.73 |
2021 | 10 | B208+Chetak | 2812.39 |
2021 | 10 | GFPL-Mfg. | 766.98 |
2021 | 10 | GFPL-Trading | 309.14 |
2021 | 10 | FP | 1285.43 |
2021 | 10 | SKG | 1388.37 |
2021 | 10 | Vizag | 1241.34 |
2021 | 11 | B208+Chetak | 2561.90 |
2021 | 11 | GFPL-Mfg. | 489.24 |
2021 | 11 | GFPL-Trading | 179.73 |
2021 | 11 | FP | 1112.71 |
2021 | 11 | SKG | 1228.46 |
2021 | 11 | Vizag | 882.90 |
2021 | 12 | B208+Chetak | 2857.22 |
2021 | 12 | GFPL-Mfg. | 806.84 |
2021 | 12 | GFPL-Trading | 370.59 |
2021 | 12 | FP | 1464.61 |
2021 | 12 | SKG | 1282.06 |
2021 | 12 | Vizag | 1532.19 |
2022 | 1 | B208+Chetak | 2368.48 |
2022 | 1 | GFPL-Mfg. | 676.61 |
2022 | 1 | GFPL-Trading | 335.02 |
2022 | 1 | FP | 1195.51 |
2022 | 1 | SKG | 1069.42 |
2022 | 1 | Vizag | 1187.84 |
2022 | 2 | B208+Chetak | 2588.50 |
2022 | 2 | GFPL-Mfg. | 748.18 |
2022 | 2 | GFPL-Trading | 331.36 |
2022 | 2 | FP | 1216.37 |
2022 | 2 | SKG | 1023.24 |
2022 | 2 | Vizag | 1032.84 |
2022 | 3 | B208+Chetak | 2343.99 |
2022 | 3 | GFPL-Mfg. | 764.08 |
2022 | 3 | GFPL-Trading | 358.39 |
2022 | 3 | FP | 1097.33 |
2022 | 3 | SKG | 1116.14 |
2022 | 3 | Vizag | 1060.37 |
2022 | 4 | B208+Chetak | 1881.43 |
2022 | 4 | GFPL-Mfg. | 590.93 |
2022 | 4 | GFPL-Trading | 250.33 |
2022 | 4 | FP | 1059.26 |
2022 | 4 | SKG | 924.98 |
2022 | 4 | Vizag | 957.04 |
2022 | 5 | B208+Chetak | 2431.42 |
2022 | 5 | GFPL-Mfg. | 656.93 |
2022 | 5 | GFPL-Trading | 213.97 |
2022 | 5 | FP | 1076.88 |
2022 | 5 | SKG | 1232.35 |
2022 | 5 | Vizag | 996.91 |
2022 | 6 | B208+Chetak | 2414.42 |
2022 | 6 | GFPL-Mfg. | 598.39 |
2022 | 6 | GFPL-Trading | 224.88 |
2022 | 6 | FP | 1121.93 |
2022 | 6 | SKG | 1221.98 |
2022 | 6 | Vizag | 1026.44 |
2022 | 7 | B208+Chetak | 1130.16 |
2022 | 7 | GFPL-Mfg. | 429.00 |
2022 | 7 | GFPL-Trading | 161.84 |
2022 | 7 | FP | 832.22 |
2022 | 7 | SKG | 1180.40 |
2022 | 7 | Vizag | 912.60 |
2022 | 8 | B208+Chetak | 1130.16 |
2022 | 8 | GFPL-Mfg. | 429.00 |
2022 | 8 | GFPL-Trading | 161.84 |
2022 | 8 | FP | 832.22 |
2022 | 8 | SKG | 1180.40 |
2022 | 8 | Vizag | 912.60 |
I'd create a Date in the script
MakeDate(Year,Month,1) as Date
Then use this expression
Sum({<Date={"$(='>=' & Date(MonthStart(Max(Date), -12)) & '<' & Date(MonthStart(Max(Date))))"}>} Sales)
Hey,Thanks .
But it's not working properly.
Actually, Suppose if I'm in September right now then its should reflect the values from Sep21-Aug22.
this is not happening.
Sum({<Date={"$(='>=' & Date(MonthStart(Max(Date), -11)) & '<' & Date(MonthStart(Max(Date))))"}>} Sales)